DSXchange

Hi,

Source is Oracle and reference stage is oracle, when we perform lookup using transformer, it returns me only the fisrt value(duplicate values) to the output from the reference stage but if we view the data from reference stage , i can see multiple distinct records.

Please adivce.

Hi,
The behaviour is normal. It will do the lookup based on the key field defined. And logically duplicate recods cant exist based on key.

Define how you want your jab to behave.


Thanks,

Only ODBC and UV stage types have the capability to supply multiple rows to a reference link. The OCI stage is behaving as documented.