1 Reply Latest reply: Feb 7, 2013 4:56 AM by mtefft RSS

    How to pass & update variable for each run in ODI


      I am new to the ODI. I am loading the data from src to trg table through interface. I want to maintain the '*create_run_cycle_id & update_run_cycle_id*' columns in the target table.

      For ex: during first run create_run_cycle_id value should be some 1 and update_run_cycle_id should be null.
      During second run create_run_cycle_id should be the same value as previous. But update_run_cycle_id value should be 2. This value should be keep on update with some value.

      For this scenario, i am using the variable, but the variable is not keep on updating based on previous value. I am not aware of the variables in ODI.

      Can anybody please help me?