Hi
I have a job like this.
Source1: Sequential File contains two columns ( A, B )
Source2: DB2 Table contains 4 columns ( A1,B1,C1,D1 )
Lookup: Source.A = Source1.A1
( Condition Not Met: Continue
Lookup Failure: Reject )
Source1: Integer type data 67219
Source2: Char type data contains Numbers ( 000000001 )
Target is Sequential File.
My goal is if Source1.A = Source2.A1 then take the output as Source1.B
But i am getting only first value from Source1.B
My job is working fine.
Please explain me what is my mistake in Lookup
Thanks
SReddy
lookup stage problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thank you Ray
I tried by enabling Multiple rows returend from link. Still i am getting same.
I tried the same job using Join stage. But data is same.
---------------------------------
69613---1---0003---4---14
69613---1---0006---8---14
69613---1---0007---6---14
Please help me what i have to do.
Thanks
SReddy
I tried by enabling Multiple rows returend from link. Still i am getting same.
I tried the same job using Join stage. But data is same.
---------------------------------
69613---1---0003---4---14
69613---1---0006---8---14
69613---1---0007---6---14
Please help me what i have to do.
Thanks
SReddy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Source1 : Sequential File contains two columns ( A, B ) -- Reference Data
Source2 : DB2 Table contains 4 columns ( A1,B1,C1,D1 )
Lookup: Source.A = Source1.A1
( Condition Not Met : Continue
Lookup Failure : Reject )
Source1 : Integer type data 67219 -- Reference Data
Source2 : Char type data contains Numbers ( 000000001 )
Target is Sequential File.
My goal is if Source1.A = Source2.A1 then take the output as Source1.B
But i am getting only first value from Source1.B
Thanks
SReddy
Source2 : DB2 Table contains 4 columns ( A1,B1,C1,D1 )
Lookup: Source.A = Source1.A1
( Condition Not Met : Continue
Lookup Failure : Reject )
Source1 : Integer type data 67219 -- Reference Data
Source2 : Char type data contains Numbers ( 000000001 )
Target is Sequential File.
My goal is if Source1.A = Source2.A1 then take the output as Source1.B
But i am getting only first value from Source1.B
Thanks
SReddy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia