ODI 12c Split & Aggregate

Hi

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.

Target 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

Final View:

Physical Diagram:

Results:

data_3 table:

data_other table