My Oracle Support Banner

How to Tweak an ODI Knowledge Module to Return Some Meaningful Information in the KM "Record Statistics" Section (Doc ID 2673641.1)

Last updated on JULY 23, 2020

Applies to:

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

Goal

Some Oracle Data Integrator (ODI) Knowledge Modules do implement code other than simple SQL commands (SELECT, INSERT, UPDATE, DELETE), which do not allow a count of the number of records processed and/or rejected.

For example, executing a Mapping using the "LKM File to Oracle (SQLLDR)" will not return any value in the "Record Statistics" section of "Call sqlldr" Session Task, simply because the LKM Task mentioned calls a database utility (SQL*Loader in the LKM example), where the "Rows" column will show 0 rather than the actual number of rows.

With the above default behavior, the operator is neither able to see the number of rows inserted, nor the ones rejected... which does considerably limit it's ability to debug the flow execution.

What customization are required to amend the above,  and give a user more visibility on the records processed?

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.