Search found 9 matches
- Thu Mar 17, 2016 2:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fetch XML CLOB data through Oracle Connector faster
- Replies: 9
- Views: 5961
- Wed Mar 16, 2016 11:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null Handling for Change capture
- Replies: 4
- Views: 5139
Re: Null Handling for Change capture
Hi,
I have had the similar situation and as far as i know, nulls on both sides will be treated as same and won't see that as a edit record.
May be internally it will assign some value to null and compare that value #thought.
Thanks,
Naresh K
I have had the similar situation and as far as i know, nulls on both sides will be treated as same and won't see that as a edit record.
May be internally it will assign some value to null and compare that value #thought.
Thanks,
Naresh K
- Wed Mar 16, 2016 9:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Clob field with Schema file
- Replies: 3
- Views: 3720
- Wed Mar 16, 2016 8:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Clob field with Schema file
- Replies: 3
- Views: 3720
Clob field with Schema file
Hi, I have a situation- Loading data from file(Fixed width) -->Tfm--> Oracle. There is a field with 600kb record size. In oracle it is defined as CLOB. So, using LONGVARCHAR in datastage i'm able to load into Oracle successfully, changing some env variables to handle the size of the data. Now, When ...
- Wed Sep 07, 2011 7:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to populate leading value in to current row
- Replies: 7
- Views: 6342
Re: How to populate leading value in to current row
Thanks for solution Melzer, it worked.
- Wed Sep 07, 2011 6:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to populate leading value in to current row
- Replies: 7
- Views: 6342
How to populate leading value in to current row
Hi, I have fields Salary & EmpNo with values as salary EmpNo 1000 10 2000 20 3000 30 4000 40 Now i need to populate records into next_sal as salary EmpNo next_sal 1000 10 2000 2000 20 3000 3000 30 4000 4000 40 Null can somebody help me on this. For the similar requirement in Oracle we can use th...
- Tue Aug 30, 2011 7:30 am
- Forum: IBM QualityStage
- Topic: How and where i can use the investigate stage(quality stage)
- Replies: 5
- Views: 10281
- Tue Aug 30, 2011 7:27 am
- Forum: IBM QualityStage
- Topic: How and where i can use the investigate stage(quality stage)
- Replies: 5
- Views: 10281
Re: How and where i can use the investigate stage(quality st
No particular reason, just want to ensure that the data which we are loading is less redundant.
- Mon Aug 29, 2011 6:04 am
- Forum: IBM QualityStage
- Topic: How and where i can use the investigate stage(quality stage)
- Replies: 5
- Views: 10281
How and where i can use the investigate stage(quality stage)
can someone let me know How and where i can use the investigate stage(quality stage) ?
I need to implement atleast one quality stage in my upcoming project.
Thanks in advance
Naresh
ETL Developer
I need to implement atleast one quality stage in my upcoming project.
Thanks in advance
Naresh
ETL Developer