X hits on this document

572 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 views572
Page views575
Page last viewedWed Jan 25 00:53:01 UTC 2017
Pages131
Paragraphs3942
Words42855

Comments