X hits on this document

384 views

0 shares

1 downloads

0 comments

48 / 131

Load

Load

Load

Reverse- Engineer

performance issues if the same file is joined with other large tables in your Interface. For optimization purpose, you can enhance this LKM by adding an extra step that copies the file content to an actual physical table in the Oracle staging area.

Consider using this LKM if your source is a large flat file and your staging area is an Oracle database.

LKM File to Oracle (SQLLDR)

Loads data from a File to an Oracle staging area using the native SQL*LOADER command line utility.

Depending on the file type (Fixed or Delimited) this LKM will generate the appropriate control script (CTL) in a temporary directory. This script is then executed by the SQLLDR operating system command and automatically deleted at the end of the execution. Because this method uses the native Oracle loader, it is more efficient than the standard “LKM File to SQL” when dealing with large volumes of data.

Consider using this LKM if your source is a large flat file and your staging area is an Oracle database.

LKM Oracle to Oracle (DBLINK)

Loads data from an Oracle source database to an Oracle staging area database using the native database links feature.

This module uses the native Oracle database links to access the source data from the target Oracle staging area. To make sure the source Oracle server properly executes all source joins and expressions, a view is created on the source in the source staging schema. The source data is not duplicated on the target staging area. It is simply referenced through an Oracle synonym. This LKM is appropriate for large volumes of data. For optimization purpose, you can enhance it by adding an extra step that copies the remote synonym's content to an actual physical table in the Oracle staging area.

Consider using this LKM if your source tables are located on an Oracle database and your staging area is on a different Oracle database.

LKM SQL to Oracle

Loads data from any Generic SQL source database to an Oracle staging area. This LKM is similar to the standard “LKM SQL to SQL” described in section “Generic SQL” except that you can specify some additional specific Oracle parameters.

RKM Oracle

Retrieves Oracle specific metadata for tables, views, columns, primary keys, non unique indexes and foreign keys. This RKM accesses the underlying Oracle catalog tables to retrieve metadata. It is provided as an example only.

In most of the cases, consider using the standard JDBC reverse engineering instead of this RKM. However, you can use this RKM as a starter if you plan to enhance it for adding your own metadata reverse-engineering behavior.

Knowledge Modules Reference Guide

48/131

Document info
Document views384
Page views387
Page last viewedWed Dec 07 15:15:06 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments