For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
I moved this to the ODI forum....
Someone has comment on this. Thanks
Depends on your definition of 'good' data. If you can express your criteria in terms of database constraints (uniqueness, referential constraints, check constraints) then ODI's CKMs can help. A CKM verifies incoming data against those constraints and puts records that violate any into an error table. Basic but effective. They appear to have been omitted in recent documentation, but to my knowledge this older guide is still valid. Have fun, Marco
Thanks Marco. How to implement The rows failing the conditions will be inserted in an error table which are prefixed by E$_? Which IKM can I use? Does IKM exist or not? Thanks a lot Loan
E$_
Hi Loan, It is the CKM that does that. You can select it in the same way you pick you IKM: on the physical tab of your mapping with the target selected. Did you spot the link to the tutorial? https://docs.oracle.com/cd/E21043_01/integrate.1111/e12641/quality.htm
Have fun, Marco
Hello Loan, If you aren't able to find any IKM which I had a hard time finding it so made a post https://community.oracle.com/tech/apps-infra/discussion/4484961/import-create-integration-knowledge-modules Look at the answer accepted, thanks to @marco-fris3 for helping me out finding where to import
ET