Creating new records in DataStage
Posted: Wed Nov 01, 2006 3:33 pm
Hi,
Please help me in doing this.
--INPUT RECORDS
-------------------------------------
ColA|ColB|ColC|ColD
A1 | A2 | ALL |A4
B1 | B2 | B3 |B4
C1 | C2 | C3 |C4
-----------------------------------------
Whenever I found the word ALL in ColC, I have to create a new 3 records, the value of ColA, ColB and ColD will be same. Instead of ALL I should have the value X in one record, Y in one record and Z in one record
-----------------------------------------------------------------
I want the output records like
----------------------------------------
ColA|ColB|ColC|ColD
A1 | A2 | X | A4
A1 | A2 | Y | A4
A1 | A2 | Z | A4
B1 | B2 | B3 | B4
C1 | C2 | C3 | C4
-----------------------------------------
Please let me know, how can I do in Datastage,
Regards,
Prasad
Please help me in doing this.
--INPUT RECORDS
-------------------------------------
ColA|ColB|ColC|ColD
A1 | A2 | ALL |A4
B1 | B2 | B3 |B4
C1 | C2 | C3 |C4
-----------------------------------------
Whenever I found the word ALL in ColC, I have to create a new 3 records, the value of ColA, ColB and ColD will be same. Instead of ALL I should have the value X in one record, Y in one record and Z in one record
-----------------------------------------------------------------
I want the output records like
----------------------------------------
ColA|ColB|ColC|ColD
A1 | A2 | X | A4
A1 | A2 | Y | A4
A1 | A2 | Z | A4
B1 | B2 | B3 | B4
C1 | C2 | C3 | C4
-----------------------------------------
Please let me know, how can I do in Datastage,
Regards,
Prasad