Page 1 of 1

Getting more records while using lookup

Posted: Tue Jan 30, 2018 9:07 am
by deesh
Hi,
I am using lookup, from main Stream getting 3582, and from reference getting 112 records , but lookup output 16201 records.

Using continue( left join), if we mention continue output should match 3582.

Please help me out, if some one faced this kind of issue

Posted: Tue Jan 30, 2018 3:48 pm
by qt_ky
Perhaps you have the Lookup stage set to allow multiple records to be returned from the reference link.

Posted: Tue Jan 30, 2018 7:15 pm
by deesh
From reference getting distinct records.

Posted: Wed Jan 31, 2018 2:53 am
by ray.wurlod
How do you know that? How else could you get more records out than came in on the stream input?

Are you using Auto partitioning?