X hits on this document

406 views

0 shares

1 downloads

0 comments

79 / 131

Yes|No

Yes

Yes|No

Yes

Yes|No

Yes

RECYCLE ERRORS

_

STATIC CONTROL

_

TRUNCATE

Set this option to YES, to recycle data rejected from a previous control.

Set this option to YES, to control the target table after having inserted or updated target data.

Set this option to YES, to truncate the target datastore.

DELETE_ALL

Yes|No

Yes

CREATE_TARG_TABLE

Yes|No

Yes

DELETE TEMPORARY_O BJECTS

_

Yes|No

Yes

FLOW_TABLE OPTIONS

_

NOLOGGING

No

COMPATIBLE

9

Yes

Set this option to YES, to delete all the rows of the target datastore.

Set this option to YES, to create the target table.

Set this option to NO, to retain temporary objects (tables, files and scripts) after integration. Useful for debugging.

Option for Flow table creation. Use this option to specify the attributes for the integration table at create time and used for increasing performance.

This option is set by default to NOLOGGING (valid only from Oracle v8).

This option may be left empty.

RDBMS version of staging/target. This option affects the use of PURGE key word and the way statistics are collected:

Values PURGE

10

Yes

9

No

8

No

STATS

DBMS STATS

_

DBMS_STATS

ANALYZE

VALIDATE

Yes|No

Yes

DETECTION STRATEGY

NOT EXISTS

Yes

_

Knowledge Modules Reference Guide

79/131

_

Validate KM options. This option generates an extra validation step during development. Validations performed are:

validation of KM option COMPATIBLE

validation of RDBMS version of staging database

validation of KM option DETECTION_STRATEGY

This option should be turned off for all production use in particular for high-frequency execution. There is not added value in production, only processing overhead.

Strategy to identify useless update. Valid values are

  • -

    MINUS: used when populating flow table in

order to exclude records, which identically exist

Document info
Document views406
Page views409
Page last viewedFri Dec 09 09:43:19 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments