DSXchange

Hi,
In my job i need to join a parent column from DataSet to child records in DB, The DB table is big, so i ruled out normal lookup but sparse lookup does not allow multiple records from reference link.
How can i use a query like
select * from child table where col1=ORCHESTRATE.col1 and join to parent record.
Thanks in advance

A sparse lookup does not allow multiple reference links, as far as I know it still allows multiple rows to be returned by a link.

If you are allowed to create a temporary table in Oracle, dump the dataset data into a table where the child oracle table resides and then push down the join operation as SQL between both tables, the temp table as outer joined table.

If you are allowed to create a temporary table in Oracle, dump the dataset data into a table where the child oracle table resides and then push down the join operation as SQL between both tables, the temp table as outer joined table.

Thanks Shamshad. I had the oracle table as an option, went ahead with that as i could not find any other alternative.