I have a requirement where I have to transpose records from row to column like the followings.
Input records coming from flat fie as follows
A,B,1,2,3,4,5,6
C,D,1,2,3,4,7,8
E,F,2,5,4,7,8,9
Considering the first two fields are the business key and rest are the different measure value.
Output records will be (let say for the first record split)
A,B,1
A,B,2
A,B,3
A,B,4
A,B,5
A,B,6
like this way for others also.
Will it better in performance perspective to implement in Pivot enterprise stage or in transformer loop.
Considering we are using datastage 8.5
Column to row transpose in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am