This content has been marked as final. Show 2 replies
You have to work out your transformations in ODI designer .. "Diagram" and in "Flow" tabs.
Now to do
1. Lookup -- bring up the lookup tables in the datastore by reversing(same like ur source and target tables/views) and drag in the designer along with ur source for transformations. do ur txfm by either drag n drop or post ur query in the "Expression Editor" by selecting the target column.
2. Insert/Update- will be controlled by ur ODI IKM`s (Incrementel Update)
3. I dont know about router Txmf.
Visit : http://www.oracle.com/technology/products/oracle-data-integrator/10.1.3/htdocs/1013_support.html for ODI docs