ODI 11g – Oracle Multi Table Insert
- by David Allan
With the IKM Oracle Multi Table Insert you can generate Oracle specific DML for inserting into multiple target tables from a single query result – without reprocessing the query or staging its result.
When designing this to exploit the IKM you must split the problem into the reusable parts – the select part goes in one interface (I named…