Restructure stage in datastage
Posted: Thu Apr 25, 2013 1:47 am
I have read on restructure stages(combine stage,subrecord stages, vector stages) in developer guide(IBM) and also in the various sites, but didn't get any clear idea about how to use these.
I want to use these stages in the following scenerio.
Input records:
COL1 COL2
1 A
1 B
2 C
2 D
3 E
3 F
4 G
4 H
Output records:
COL1 COL2 COL3
1 A B
2 C D
3 E F
4 G H
It is very much possible to make it with Pivot Enterprise stage by using in Vertical Pivot mode.
Can you please let me know whether it is possible to achive this by using the restructure stages(combine stage,subrecord stages, vector stages).
I want to use these stages in the following scenerio.
Input records:
COL1 COL2
1 A
1 B
2 C
2 D
3 E
3 F
4 G
4 H
Output records:
COL1 COL2 COL3
1 A B
2 C D
3 E F
4 G H
It is very much possible to make it with Pivot Enterprise stage by using in Vertical Pivot mode.
Can you please let me know whether it is possible to achive this by using the restructure stages(combine stage,subrecord stages, vector stages).