4 Mayıs 2016 Çarşamba

ODI 12c Split & Aggregate


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:


data_3 table:

data_other table

Hiç yorum yok:

Yorum Gönder