ODI 12C SCENARIO Agenda: Mapping Source Unique and Duplicate record into different different target using ODI 12c Mapping Source Table: EMP_INFO Source Table Data: Target Table: EMP_INFO_TAR1 ( For Unique Record) Target Table Expected Data: EMP_INFO_TAR1 ( For Unique Record) Target Table: EMP_INFO_TAR2 ( For Duplicate Record) Target Table Expected Data: EMP_INFO_TAR2 ( For Duplicate Record) Used ODI components: JOIN AGGREGATE FILTER SET SPLIT Step By Step Implementation Process: Step 1: Drag source table twice in the mapping area. Connect both table with aggregate component as like above diagram Add 1 column into the both aggregate attribute. Name as status and in Expression column place value 1, 2. Step 2: Connect each Aggregate compon...
Learn Oracle Data Integrator Scenario Wise
Here I am trying to post ODI related scenarios and Question which feel me bit challenging for the new learners.