ODI - Check Knowledge Module (CKM)
About
The flow control strategy lets you define the method used to check the flow before the insertion in the target. It's defined in an interface by a Knowledge Module, the Check Knowledge Module (CKM) as :
- CKM HSQL: The Check Knowledge Module for Hypersonic SQL
This module controls the validity of the constraints of a Datastore based on the Hypersonic SQL technology and rejects the invalid records into an error table. It can be used for static controls as well as flow controls.