X hits on this document

415 views

0 shares

1 downloads

0 comments

45 / 131

Oracle Database

Knowledge Modules

Refer to section “Generic SQL” for additional Knowledge Modules that work with this database.

Type

Knowledge Module

Description

Check

CKM Oracle

Checks data integrity against constraints defined on an Oracle table. Rejects invalid records in the error table created dynamically. Can be used for static controls as well as flow controls.

Consider using this CKM if you plan to check data integrity on an Oracle database.

This CKM is optimized for Oracle.

Integrate

IKM Oracle Incremental Update

Integrates data in an Oracle target table in incremental update mode. This IKM creates a temporary staging table to stage the data flow. It then compares its content to the target table to guess which records should be inserted and which others should be updated. It also allows performing data integrity check by invoking the CKM.

Inserts and updates are done in bulk set-based processing to maximize performance. Therefore, this IKM is optimized for large volumes of data.

Consider using this IKM if you plan to load your Oracle target table to insert missing records and to update existing ones. If you plan to use this IKM with very large tables, you should consider enhancing this IKM by removing the MINUS set-based operator.

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

Integrate

IKM Oracle Spatial Incremental Update

Integrates data into an Oracle (9i or above) target table in incremental update mode using the MERGE dml statement. This IKM creates a temporary staging table to stage the data flow. It then compares its content to the target table to guess which records should be inserted and which others should be updated. It also allows performing data integrity check by invoking the CKM.

Inexistent rows are inserted; already existing rows are updated.

Data can be controlled. Invalid data is isolated in the Error Table and can be recycled.

When using this module with a journalized source table, it is possible to synchronize deletions.

This module allows to handle SDO_GEOMETRY datatype which must be declared in the Topology.

Knowledge Modules Reference Guide

45/131

Document info
Document views415
Page views418
Page last viewedFri Dec 09 20:58:57 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments