This IKM integrates data into an Oracle target table in append mode. All records are inserted without any key checks. Data can be controlled by isolating invalid data in the error table and recycling when fixed.
Note:
This IKM now supports ETL diagnostics and automatic corrections. The flow control option is no longer used with this IKM.Prerequisites
If the "Synchronize Deletions from Journal" process is executed, the deleted rows on the target are committed.
To use the RECYCLE_ERRORS option, the update key must be set on the interface.
Options for Functionality
Unspecified Record — If the target table is a dimension, set this option to TRUE to automatically insert an "Unspecified" record. This is referenced by facts in case no other dimension record matches. The default column values are determined by model naming standards using the user-defined function GET_UNSPEC_VALUE.
Options for Performance Tuning
Hints — This IKM allows the passing of hints into the generated SQL. For more information, see the article titled "Oracle Business Intelligence Applications Version 11g Performance Recommendations" (Doc ID 1963225.1) on My Oracle Support.
Alter Session List — Applies a list of alter session commands to the session used by the KM. Commands should be separated by a semi-colon and without the "ALTER SESSION" prefix. Each command should be prefixed SRC or TGT depending on whether it should be executed on the source connection (relevant if using an LKM) or the target connection. For example:
SRC set TRACEFILE_IDENTIFIER='ODI_TRACE'; SRC set events '10046 TRACE NAME CONTEXT FOREVER, LEVEL 8'; TGT set TRACEFILE_IDENTIFIER='ODI_TRACE_TGT';