My Oracle Support Banner

White Spaces Are Added when Inserting Data from Fixed Format File to Database Using ODI 12.2.1.4.0 (Doc ID 2904312.1)

Last updated on AUGUST 18, 2023

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Oracle Data Integrator - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Data Integrator (ODI) release 12.2.1.4.x and loading data from file to Oracle in a mapping.
If a fixed format file with a column of 6 character is loaded, and the attribute value is set to 20 characters, ODI will insert 20 characters, adding 14 blank spaces.

This was not observed in ODI 12.2.1.3 where there were no blank spaces added when loading files format files.

To reproduce:

  1. Create a fixed file data server and model
  2. Make sure that one of the fixed file format columns has column size set to 20 characters
  3. Create a file that only has 6 characters for the same column of actual data, and fill the rest of the 14 characters with blank spaces
  4. Create a mapping loading fixed file format to Oracle
  5. Execute the mapping and look at the data loaded in the target table


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!

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