In this entry , i will show how to use split and aggregate objects of ODI 12c.
* Source Table: data_1
What i am gonna do is implementing a multi insert mapping which loads data into different tables.
data_3 ( it only holds data whose group_name is 'GROUP1' )
data_other ( it only holds data whose group_name is not 'GROUP1' )
Step1: Adding tables and split object
Step2 : Setting up split object properties
Step3: Adding aggregate object for data_3 table