Using ODI variables to dynamically specify Table column names

When mapping between source and target data stores, it is possible to parametrize column names usingODI variables ..


By defining an ODI variables such as MyVar and by referencing it in a mapping such as:


TARGET.COL1 = SOURCE.#MyVar


ODI will substitute for it at run time with its value.


Note: 


Take care , however , in assigning a valid column name from the SOURCE table to the variable