[ODI 11] Multi-Table Insert KM

 Multi –Table Insert KM

ODI 11g presents the a new KM called Multi Insert Table which enables to Insert data from one source into one to many Oracle target tables in append mode, using a multi-table insert statement (MTI).

Here is a small example to show its functionality. Here in this we are loading the Source table Employees to Multiple Target table ( employees1, employees2, employees3 ).

Create the First Interface and lets name it – Parallel_load_emp1.

and set the IKM option as following

Create the Second Interface and lets name it – Parallel_load_emp2.
And set the IKM options as follows

 

Create the Third Interface and lets name it – Parallel_load_emp3.

And set the IKM options as follows

In short the First Interface should have the DEFINE_QUERY – True and the Final Interface EXECUTE – True

We create a package called MULTI_TABLE_INSERT_EMPLOYEES and arrange the Interface as per the required Order.

 

As we can see In the above image of the operator run , we find that it kept adding the Target table for each interface run and finally ran the MTI condition and load the data into the Multiple target as shown below

This KM can be used to perform Insert only