My Oracle Support Banner

OBIA 7964: Informatica 10.2 Rejecting Rows Instead of Truncating Values Exceeding Column Width (Doc ID 2728849.1)

Last updated on NOVEMBER 18, 2020

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Symptoms

OBIA 7964

Source Database: Microsoft SQL Server 2012

Target Database: Oracle Database 12.1.0.2

While loading data from Source to Target DW, if the value exceeds the target column width, Informatica 9.6.1 was truncating the value as there is difference in data type of source and target, but Informatica 10.2 is rejecting the entire row.

 

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


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