Substitution Methods Like getTargetColList() and getColList() Do Not Pick Columns with User Defined Flag in ODI 12c
(Doc ID 2697721.1)
Last updated on AUGUST 10, 2020
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 to 184.108.40.206.200618 [Release 12c]
Information in this document applies to any platform.
Oracle Data Integrator (ODI) substitution methods, like getTargetColLit() and getColList(), do not pick UserDefined (UD) columns while extracting the column Expression to form the select query of a SQL merge statement. As a result of this, the expression for columns with only UD flag attribute selected are created as an empty string ('') and not the actual out-of-the-box or custom expressions.
- A mapping is designed on ODI 220.127.116.11.0 which has User Defined logic defined on the knowledge module.
- The knowledge module used for this Mapping is "IKM Teradata SCD (Business Data). This is a customized knowledge module to use the User Defined logic.
- The knowledge module uses substitution methods like getTargetColList and getColList().
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document