Hi,
Iam using a job that is performing a lookup function with db2 stage API.
I have a file and there are 24 records and DB2 table has 4 records and when I am performing lookup based on key columms in lookup stage Iam getting all the 24 records but I want only 4 records that is from the table db2.
Thanks
Somaraju
Doubt in Lookup
Moderators: chulett, rschirm, roy
Doubt in Lookup
somaraju
You are trying to do a Left outter join. The values that match the Lookuptable will only be outputted or if you pass the link from the source to the target also, then the matched and non-matching columns both would be in the result.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Hi Dsguru,
I have defined a leftouterjoin and Iam haning Ch,Cu and Date as key columm and I am getting only 14 rows out of 24
date key (it is there in file and table),date1(fromfile it is only in file)
ch,cu,date,date1
R,1,2,1
O,1,3,2
R,2,2,1
R,1,3,2
Iam getting only above two only from output and Iam not getting the bottom two
Thanks,
Somaraju
I have defined a leftouterjoin and Iam haning Ch,Cu and Date as key columm and I am getting only 14 rows out of 24
date key (it is there in file and table),date1(fromfile it is only in file)
ch,cu,date,date1
R,1,2,1
O,1,3,2
R,2,2,1
R,1,3,2
Iam getting only above two only from output and Iam not getting the bottom two
Thanks,
Somaraju
somaraju
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: