Hi ,
I used combine records stage in datastage my meta data in the input dataset is name varchar2(100),marks integer(10).My output dataset metadata is comb char(1000).when I use combine record stage (key is name)I get 3 rows output from the link. My input data is
x1,100
x1,90
x,390
x4,50
but when I view the output dataset I just see () braces with no value.Kindly advice.
Combine Record Stage data issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try using Runtime Column Propagation and look at what DataStage produces. You should be seeing records containing subrecords made up of the input records (which explains the braces). You have to be particularly careful of nullable fields.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: