DSXchange

apoorvadwi: Confused with "3 nodes & 7 partitions =21" can you please brief on your settings please..

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

Ray, you mean- we should go with Custom job with metadata defined instead of a generic one?

Thanks,
Naresh K.

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 ...

Thanks for solution Melzer, it worked.

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...

Hey Arving thank you very much for the suggestion, but i went through the document long back itself, couldn't understand a bit.
Can you please suggest me any sites where the documents will be more clear and from scratch.

No particular reason, just want to ensure that the data which we are loading is less redundant.

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