Description:
- Check Knowledge Module for Oracle
- This module controls the validity of the constraints of a Datastore and rejects the invalid records in an error table. It can be used for static controls as well as flow controls.
- This module creates non unique index on the I$ table before checking AK and PK and an index on the E$ table before removing erroneous records from I$ table.
Restrictions:
- Data cleansing can be performed only if an update key is defined on the controlled table.
- This Knowledge Module uses Oracle RowId column for data cleansing.
Change History:
JAN-2011:
- Fix error table naming to use resource name rather than table name
APR-2008:
- Fixed 6833779: "insert PK errors", "insert AK errors": Added support for SDO_GEOMETRY and XMLTYPE
JAN-2008:
- optimized PK and AK ckecks using self-joins for tables wo/ LOBs
- Added indexes on flow and error table
- Check Knowledge Module for Oracle
- This module controls the validity of the constraints of a Datastore and rejects the invalid records in an error table. It can be used for static controls as well as flow controls.
- This module creates non unique index on the I$ table before checking AK and PK and an index on the E$ table before removing erroneous records from I$ table.
Restrictions:
- Data cleansing can be performed only if an update key is defined on the controlled table.
- This Knowledge Module uses Oracle RowId column for data cleansing.
Change History:
JAN-2011:
- Fix error table naming to use resource name rather than table name
APR-2008:
- Fixed 6833779: "insert PK errors", "insert AK errors": Added support for SDO_GEOMETRY and XMLTYPE
JAN-2008:
- optimized PK and AK ckecks using self-joins for tables wo/ LOBs
- Added indexes on flow and error table
No comments:
Post a Comment