My Oracle Support Banner

ODI and the Use of SQL*Loader LKM with a Subset of Fields of a Delimited Flat File (Doc ID 423723.1)

Last updated on AUGUST 24, 2023

Applies to:

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

Goal

It is required to load into Oracle only a subset of fields present in a large delimited source file.

How can Oracle Data Integrator (ODI) achieve this using the standard "File To Oracle (SQLLDR)" LKM (Loading Knowledge Module)?

For example, a delimited flat file consisting of the following fields C1, C2, C3, C4 and C5 and only fields C3 and C5 are to be loaded.

Solution

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.