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 and later
Information in this document applies to any platform.


OBIA 7964

Source Database: Microsoft SQL Server 2012

Target Database: Oracle Database

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.





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

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