DATA SETS

DataSets

Using UNION ,INTERSECT ,UNION ALL MINUS

STEP 1 : Creating and Reverse Engineering Source

1. Connect to Source schema (SCOTT)
2. Execute below scripts

create table EMP10 AS select * from emp where deptno=10 create table EMP20 AS select * from emp where deptno=20

3. We can use EMP table of SCOTT schema as source
4. Reverse engineer EMP10 and EMP20  table into SOURCE  MODEL

STEP 2 : Creating and Reverse Engineering Target

1. Connect to Target Schema (TDBU)

create table EMP1020 AS select * from scott.emp where 1=2

2. Reverse engineer into TARGET MODEL

STEP 3 : Creating Interface/Mapping

1. Create interface with the name of m_Data_Sets
2. Click on mapping tab → Drag and drop source (EMP10)and target (EMP1020) in respective locations

3. Click on add/Remove Data Set → Click on Add new dataset
4. change name as EMP20 → select  operator as UNION → Click on Close

5. Drag and drop EMP20 source into source work area
6. 
7. Click on Flow tab
8. Select Target and select IKM SQL CONTROL APPEND
9. Select FLOW_CONTROL = False

10. Click on SAVE
11. Click on RUN
12. Observe output
13.