Hi all,
I am just a data stage beginner. I've been searching on the forums on whether it's possible to merge multiple rows from different sources into one row. So far the pivot stage seems to be the closet thing to what I want but I'm still not sure it will meet my requirements. Let me explain.
I have a stream of data in my parallel job that starts off at an oracle stage. It returns three rows. From the oracle stage I have three transformers. Each to handle the three different types of data.
The output columns of the first transformer is the following columns...
Member no, member valid
The output of the second transformer is ...
Staff no, staff valid
The output of the third transformer is ....
Valid card
Normally you would end up with three output rows but My question is how can I end up with one row which combines the content of the three rows...
Member no, member valid, Staff no, staff valid, Valid card
All these rows do have a transaction key in common which I can use if required. What stage would best be suited for what I want?
Thanks for your help.
Multiple rows from different sources into single row
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 27
- Joined: Tue Jan 05, 2010 12:04 am
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
You can use join stage of type inner and your joining key will be transaction key.
You can use join stage of type inner and your joining key will be transaction key.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 27
- Joined: Tue Jan 05, 2010 12:04 am
But the trick with my scenario is that all three transformers lead back to the same oracle enterprise stage. So the rows coming out of the transformers come out one by one. I.e. I want to read all the rows then after all rows are read combine output as originally described.
For a join to work you need rows coming from each input link at the same time right?
For a join to work you need rows coming from each input link at the same time right?
-
- Premium Member
- Posts: 27
- Joined: Tue Jan 05, 2010 12:04 am
-
- Premium Member
- Posts: 27
- Joined: Tue Jan 05, 2010 12:04 am