Lookup Opeartion

srinivas.g · Post by **srinivas.g** » Wed Jun 24, 2009 11:48 pm

Hi all,

In source query iam getting records like
63573
123
Look up query iam getting reocrds like
63573
63573
63573
63573

in target iam getting only 1 record.but i want 4 records in target (4 are matching records)

Please help me

DS_SUPPORT · Post by **DS_SUPPORT** » Thu Jun 25, 2009 12:43 am

It depends , what stage you are using for a lookup and also your target Key Structure.

You have to use Universe Stage or ODBC stage , to return Multiple row set from the lookup. Search the forum with the keyword "Reference Link with Multi Row Result Set", you will find ways on how to implement it.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 25, 2009 1:40 am

If the input brings unique keys, you can reverse the main and reference streams.