Flow Control in ODI12c

Scenario:
While loading 10000 records if there is an error in one record then I need to load that record into E$ (error table) and rest of records into target table.

Example:
Source

As per requirement, whose MID values are null consider to be invalid records

(i.e., SRC = TRG+E$)

Flow Control:

Data quality validation is done before loading the data into target tables.

Check Control Knowledge Module (CKM) will create E$ table and SNP_CHECK_TAB table for data quality check.

It will validate data in I$ table before inserting data into target table.

If it has any errors then it will delete from I$ table and insert into E$ table and common error message and interface name into SNP_CHECK_TAB

Approach:

Step 1:

Create Model -- Reverse Engineer source datastore and target datastore 

Step 2:

Expand Target data store -- Right click on constraint --Select  "New Condition"

Message is nothing error message

Actually this is condition is not there at data server level. Type indicates it is ODI condition.

Step 3:

Go to Control tab and enable check box for both flow control and static control

Step 4:

Create mapping -- Drag and drop Source and target data store then connect source output connector to target input connector -- go to physical tab and then select target datastore -- go to Property Inspector -- Integration Knowledge Module --  Enable Flow control as true 

[*Note: There should be key if we enable flow control. In my example EMPID is key column]

Step 5:

Execute it

Output: