DSXchange

Hi guys,
I have a set of values in a dataset. I need to pass this value in oracle stage query window. Can any one suggest a solution if you come across.

Eg:

Dataset has thousands of reocrds.
156
245
335
424
.
.
.
1454

in the Database stage i have the query

Select * from empy where emp_ID = Dataset Value
Select * from empy where emp_ID = 156
Select * from empy where emp_ID = 245
and so on

how to achieve this..

Hi Murali,

Perform a lookup or use a join stage between the Dataset and the database table.

Mansoor - I need to pass the dataset value dynamically inside the database query.
The database has the query but does not have data in load.

Use sparse lookup if you want to pass the value dynamically, but this is preferable based on the amount of data you are having it in source and reference link.

Priya,

the data load will be around some 500K so, is this preferable to take on sparse matrix.