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