X hits on this document

375 views

0 shares

1 downloads

0 comments

80 / 131

in target.

- NOT_EXISTS: used when populating flow table in order to exclude records, which identically exist in target.

- POST_FLOW: all records from source are loaded into flow table. After that an update statement is used to flag all rows in flow table, which identically exist in target.

- NONE: all records from source are loaded into flow table. All target records are updated even when target records is identical to flow table record.

Yes

Check this option if you wish to analyze the target table before loading data into the integration table.

No

Use this option to specify the hint (string) to be used while loading the integration table.

No

Set this option to Yes, to refresh the MOLAP cube for an Analytical Workspace. If this option is set to YES, the following cube specific options are mandatory:

AW_OWNER, CUBE_NAME, and

Yes, if REFRESH_ CUBE is set to Yes

Analytical Workspace owner

Yes, if REFRESH_ CUBE is set to Yes

Analitical Workspace Name

Yes, if REFRESH_ CUBE is set to Yes

MOLAP cube name.

ANALYZE TARGET

_

OPTIMIZER HINT

_

REFRESH CUBE

_

Yes|No

Yes|No

AW_OWNER

string

AW_NAME

CUBE NAME

_

string

string

Knowledge Modules Reference Guide

80/131

Document info
Document views375
Page views378
Page last viewedTue Dec 06 19:13:45 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments