Hi,
Can you please give the suggestion for the below task,
my source:(file)
month1,month2,month3,month4--columns
1,2,3,4
2,1,3,4 ---data
Lokup table:
months:
1
2
3
So my requirement is i need to check the each column from the source to lookup column and pass the record to target,
is it possible take one lookup satge and send the data to target?
multiple columns need to be lookup one table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Who knows? Define "performance". Nothing to prevent you using more than one Lookup stage if monitoring shows that one Lookup stage with many reference inputs is a bottleneck in the job design.
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.