30 Mayıs 2016 Pazartesi
Import location for ODI 12c knowledge modules
Hi
ODI 12c KMs can be imported from the directory below
Installation_Directory\ODI\odi\sdk\xml-reference
Example:
C:\ORACLE\ODI\odi\sdk\xml-reference
4 Mayıs 2016 Çarşamba
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
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
Kaydol:
Kayıtlar (Atom)