Passing Dataset value to Oracle Database stage

Murali4u · Post by **Murali4u** » Fri Feb 25, 2011 1:29 am

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

mansoor_nb · Post by **mansoor_nb** » Fri Feb 25, 2011 1:48 am

Hi Murali,

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

Murali4u · Post by **Murali4u** » Fri Feb 25, 2011 2:58 am

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.

priyadharsini · Post by **priyadharsini** » Fri Feb 25, 2011 3:19 am

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.

Murali4u · Post by **Murali4u** » Sat Feb 26, 2011 7:19 pm

Priya,

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