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

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

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