lookup stage problem

[sreddy]

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

[ray.wurlod]

Have you enabled "multiple row return from reference input"?

[sreddy]

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

[priyadarshikunal]

can you please rephrase your problem statement as its not descriptive enough for me and give example including input and output.

[sreddy]

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

[keshav0307]

can you put some example of source1 and source2 data. and what is you are expecting in the output