Hi Guys,
If my souce is having one row of data and for the source row if i have multiple rows in the lookup satisfying the criteria that i define, is it possible to create multiple rows in the target for each lookup ??
For Example.
Source Table
S.NO Name Parent
1 AB01 CD01
2 AB02 CD02
Lookup Table
S.NO Name Parent
1 CD01 5
2 CD01 5
3 CD02 7
I want my result set to be
S.NO Name Parent
1 AB01 5
2 AB01 5
3 AB02 7
please provide me your inputs.
Answers appreicated.
Multiple row generation for a single row source
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No such animal in a server job.
If your secondary reference set is ODBC-accessible, then multiple rows per lookup can be returned.
If both inputs are sequential files (or can be made sequential files) then you could perform a join in a Merge stage.
If your secondary reference set is ODBC-accessible, then multiple rows per lookup can be returned.
If both inputs are sequential files (or can be made sequential files) then you could perform a join in a Merge stage.
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: 11
- Joined: Sat Mar 13, 2010 12:00 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: