My Oracle Support Banner

How To Load Data from Fixed Length Files Directly from the Source to the Target Without Creating Any Temporary Table (Doc ID 1187283.1)

Last updated on JUNE 16, 2022

Applies to:

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

Goal

This article describes the specific case to load data from "Fixed Length Files" directly from source to target without the use of Staging Area.

If the intention is to Load Data from other sources, including flat files separated by a character, please refer to:

<Note:762723.1> - How To Load Data Directly From The Source To The Target Without Creating Any Temporary Table In an ODI Integration Interface?

which follows the approach of creating a custom IKM, as a fusion of LKM File to Oracle (sqlldr) and IKM SQL to SQL Append. Such approach unfortunately does not work for fixed length files, thus the existence of this article.

If using the above approach, then SQL*Loader control file is not generated correctly:

Example of CTL file:

A new type of KM needs to be created (an LKM) as the the IKM has a restriction to deal with Fixed Length Files.

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!


In this Document
Goal
Solution
References


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