2 Replies Latest reply on Feb 26, 2014 7:21 PM by user2434406

    Looping through all values of a variable in ODI


      Hi All,


      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.