I have just created an ODI interface which executed successfully.
I have three constraints on the source datastore: PK, FK and a check constraint.
All the invalid records are showing on the E$ table.
But the problem is that the target table is still showing those records that suppose to be isolated.
I checked the control tab of the interface and could only see the PK but not the FK and the check.
The flow tab tab shows the IKM and the control tab shows the ckm.
Please can you tell me what I have missed.