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 JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 10.1.3.4.0 and later
Information in this document applies to any platform.

Goal

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.

Solution

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
Goal
Solution
References

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