Set Component in ODI 12c

It behaves like SQL set operators (union, Minus, Intersect and except).UNION is chosen by default.

Pre-requisites:

1.    ODI 12c

2.    Oracle database

3.    KM: Default (IKM and LKM).

IKM: IKM Oracle Insert.GLOBAL

LKM: LKM Oracle to Oracle Pull (DB Link)

RKM: Default

4.    Components : SET

Source Tables : union_src1

union_src2:

Procedure:

·         Establish connections physical and logical connection in topology for source and target tables.

·         Import the table in model in using Reverse engineering KM

·        

• Drag the source table (union_src1 and union_src2) from model to logical diagram.
• Drag the component   from component pallet into logical diagram.
•  
• 

 

• Drag target table UNION_TRG from model to logical diagram.
• Establish connection between union_scr1 and SET Component. Now SET component has attributes with yellow colour arrows.
• Establish join between union_src2 and SET Component. Now it shows Grey arrows.
• Edit SET component properties.

 

 

Note:

·         We should define attributes in set component if different from source attributes.

·         INTERSECT ALL, MINUS ALL, MINUS DISTINCT, INTERSECT DISTINCT, EXCEPT ALL, EXCEPT DISTINCT and EXCEPT   are not supported for oracle technology

·         Establish connection between SET component and target table.

 

·         Leave it with default KMs(IKM Oracle Insert.GLOBAL) and LKM(LKM Oracle to Oracle Pull (DB Link)).

·         Save the mapping.

·         Run the mapping and see logs in operator.

Completed Successfully.

 

·