DSXchange

Thank you. My problems solved

I have found my answer.

Hi, I have to load data from a single table into multiple table based on a column value from the source table. Eg, SOURCE TABLE code value date ------------------------ XXX 123 4/4/2006 YYY 333 8/7/2006 ZZZ 444 24/12/2006 and the code XXX,YYY,ZZZ indicates to which table the date has to go. I m usin...

All the answers in this forum seems to be only for the paid users. I cannot view your answer...

Have to check out some other forum.

Anyways thanks for responding.

My question is not answer :(

:roll:

How do I apply constraint in the transformer.?
I used

if TABLE_CODE = 'XXX'
then
input.Filler_1
else
log message

I want to know if there is any other approach for the same

Hi,
Thank you for the suggestion on the subject line. Will always keep in mind.

And also thanks a lot for your suggestion on the query.

Hi, I am very new to DataStage and Data warehousing. I am using DataStage 7.5.1 on Windows. I want to insert data from a single csv into database (Oracle 10g). The CSV File looks something like this: XXX,001,PO,06/06/2006,USER XXX,002,PR,08/12/2006,USER YYY,APE,1200,EUR,12/12/2005,USER YYY,ARE,1200,...