My Oracle Support Banner

How To Edit the ODI Knowledge Module to Apply a Database Function to the Mappings (Doc ID 787977.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Oracle Data Integrator - Version to [Release 10gR3 to 11gR1]
Information in this document applies to any platform.


Sometimes the data from the source could contain null values or zero length strings. To deal with such values (for example insert them as NULL in target ), you could use a CASE WHEN or NVL function in the mappings if your source or target or staging area is Oracle.

However, when the target table contains many columns, it can be a long process to add the CASE WHEN or NVL to the mappings of each of such fields.

This Note shows how to add such function into the Integration Knowledge Module's code so the CASE WHEN or NVL is automatically generated for you in the Select SQL statement.

Note: IKM modification assistance falls outside the realm of support.  If assistance is needed, please contact Oracle Consulting.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.