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

    Looping through all values of a variable in ODI

    DivasP

      Hi All,

       

      I have a table table1 with dates fields in that

      so the table will be some thing like

      Date_column

      1-Jan-2014

      4-JAN-2014

      5-JAN-2014.

       

      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.