My Oracle Support Banner

ODI 12c Warning Message "The size of mapped source attribute is greater than the size of target attribute" Is Received when a Source Column <SOURCE COL1> Is Used in the Condition of <TARGET COL> Attribute (Doc ID 2511812.1)

Last updated on MAY 06, 2019

Applies to:

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

Symptoms

The following warning message:

The size of map attribute <SOURCE COL1> is greater than the size of attribute <TARGET COL> to which it is mapped. Truncation or run time errors are possible on the technology.

... is displayed when executing an Oracle Data Integrator (ODI) 12c Mapping that loads data into a target column <TARGET COL> of datatype <TARGET DATATYPE>, using the following expression to set the <TARGET COL> attribute:

case when <SOURCE COL1> = <some value> then <SOURCE COL2> else <SOURCE COL3> end

Changes

 

Cause

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
Symptoms
Changes
Cause
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.