I have a table table1 with dates fields in that
so the table will be some thing like
I have one variable var1 declared in my project, which takes values from this table.
So the refresh definition of the variable var1 is
Select date_column from table1.
Now for each of these dates I have to run a scenario, the scenario is taking var1 date value as parameter.
This needs to be run in a loop so that all the dates in the table can be covered.
Could you please tell how this can be achieved in a package in ODI.
Able to figure out the solution for this: thanks to all the other post that helped me to get the solution.
Could you post how you were able to resolve it?