X hits on this document

402 views

0 shares

1 downloads

0 comments

59 / 131

_ FLOW_TABLE OPTI

String

ONS

Default is:

NOLOGGING

COMPATIBLE

Default is: 9

SYNC JRN DELETE

_

_

Yes|No

FLOW_CONTROL

Yes|No

RECYCLE ERRORS

Yes|No

TRUNCATE

Yes|No

DELETE_ALL

Yes|No

DELETE_TEMPORA RY_OBJECTS

Yes|No

Yes|No

_

STATIC CONTROL

_

VALIDATE

Yes|No

Commit all data inserted or updated in the target datastore.

Yes

Synchronise Journalized deletions.

Check this option to synchronize journalized deletions. This option will take effect only if one source table is journalized in your interface.

Yes

Activate Flow control.

Check this option if you wish to perform flow control.

Yes

Recycle previous errors.

Check this option to recycle data rejected from a previous control.

Yes

Post Integration Control.

Check this option to control the target table after having inserted or updated target data.

Yes

Check this option if you wish to truncate the target datastore.

Yes

Check this option if you wish to delete all the rows of the target datastore.

Yes

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

No

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.

No

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

Yes

STATS

DBMS STATS

_

DBMS_STATS

ANALYZE

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

Knowledge Modules Reference Guide

59/131

Document info
Document views402
Page views405
Page last viewedThu Dec 08 15:23:35 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments