My Oracle Support Banner

ODI File Loading Knowledge Modules Not Properly Loading Selected Columns (Doc ID 2851316.1)

Last updated on SEPTEMBER 29, 2023

Applies to:

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


When using file Loading Knowledge Modules (LKM) such as "LKM File to SQL" or "LKM Object Storage to ADWC Copy," only the first n number of columns are read, where n is the number of columns mapped overall from the file. For example, if Column2, Column4, and Column6 are mapped, the resulting loaded columns will be named Column2, Column4, Column6, however, the data will be from Column1, Column2, and Column3. 


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.