i put three out put streams from the copy stage and changed the column names in the output and then i used a funnel at the end as each stream has the same columns.
Once agin thank you for your views.
Rao
Search found 65 matches
- Sun Sep 25, 2005 1:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: spilt the record into three records
- Replies: 13
- Views: 19111
- Sun Sep 25, 2005 12:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reg. trim function in modify and type conversion
- Replies: 1
- Views: 1097
reg. trim function in modify and type conversion
can i use trim function in modify stage? 1.I need to trim a string(Varchar) of length 50 to string(Varchar) of ength 12. i am using modify stage for other conversions. So I cannot use another stage for that.Is there any way i can trim it and escape from the warnings. And the other one is: 2.I am get...
- Mon Sep 19, 2005 11:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: spilt the record into three records
- Replies: 13
- Views: 19111
- Sat Sep 17, 2005 10:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: spilt the record into three records
- Replies: 13
- Views: 19111
- Sat Sep 17, 2005 4:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: spilt the record into three records
- Replies: 13
- Views: 19111
spilt the record into three records
i have a record with 4 columns key,A,B,C.I want to split the record into three records with the columns as key,type. SOURCE: key A B C 01 2 3 4 Target: key TYPE VAL 01 A 2 01 B 3 01 C 4 IS THERE ANY SHORT CUT WITH OUT USING ONE COPY STAGE, THREE MODIFY STAGES AND ONE FUNNEL. THANKS IN ADVANCE RAO