X hits on this document

365 views

0 shares

1 downloads

0 comments

47 / 131

To use this IKM, the staging area must be on the same data server as the target.

Integrate

IKM Oracle Slowly Changing Dimension

Integrates data in an Oracle target table used as a Type II Slowly Changing Dimension in your Data Warehouse. This IKM relies on the Slowly Changing Dimension metadata set on the target datastore to figure out which records should be inserted as new versions or updated as existing versions.

Because inserts and updates are done in bulk set-based processing, this IKM is optimized for large volumes of data.

Consider using this IKM if you plan to load your Oracle target table as a Type II Slowly Changing Dimension.

To use this IKM, the staging area must be on the same data server as the target and the appropriate Slowly Changing Dimension metadata needs to be set on the target datastore.

Journalize JKM Oracle 10g Consistent (LOGMINER)

Creates the journalizing infrastructure for consistent journalizing on Oracle 10g tables. Changed data is captured by the Oracle 10g Log Miner specific utility.

Enables consistent Changed Data Capture on Oracle.

Journalize JKM Oracle 11g Consistent (LOGMINER)

Creates the journalizing infrastructure for consistent journalizing on Oracle 11g tables. Changed data is captured by the Oracle 11g Log Miner specific utility.

Enables consistent Changed Data Capture on Oracle.

Journalize JKM Oracle 9i Consistent (LOGMINER)

Creates the journalizing infrastructure for consistent journalizing on Oracle 9i tables. Changed data is captured by the Oracle 9i Log Miner specific utility.

Enables consistent Changed Data Capture on Oracle

Journalize JKM Oracle Consistent

Creates the journalizing infrastructure for consistent journalizing on Oracle tables using triggers.

Enables consistent Changed Data Capture on Oracle.

Journalize JKM Oracle Simple

Creates the journalizing infrastructure for simple journalizing on Oracle tables using triggers.

Enables simple Changed Data Capture on Oracle.

Load

LKM File to Oracle (EXTERNAL TABLE)

Loads data from a File to an Oracle staging area using the EXTERNAL TABLE SQL Command.

Because this method uses the native EXTERNAL TABLE command, it is more efficient than the standard “LKM File to SQL” when dealing with large volumes of data. However, the loaded file must be accessible from the Oracle server machine.

Note that the data of the source file is not duplicated in the Oracle staging area table. This table acts only as a "synonym" of the file. This may sometimes lead to

Knowledge Modules Reference Guide

47/131

Document info
Document views365
Page views368
Page last viewedTue Dec 06 08:35:57 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments