Server lookup returns only the first value

snt_ds · Post by **snt_ds** » Thu Feb 26, 2009 1:57 am

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.

bkumar103 · Post by **bkumar103** » Thu Feb 26, 2009 3:26 am

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,

ray.wurlod · Post by **ray.wurlod** » Thu Feb 26, 2009 4:06 am

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