DSXchange

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

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.

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