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
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.