Refer to section “Generic SQL” for additional Knowledge Modules that work with this database.
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.
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.
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