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.