X hits on this document

437 views

0 shares

1 downloads

0 comments

67 / 131

Values

Mandatory

Description

Yes|No

Yes

Automatically attempts to insert data into the Target Datastore of the Interface.

Yes|No

Yes

Commit all data inserted in the target datastore.

Yes|No

Yes

Check this option if you wish to perform flow control.

Yes|No

Yes

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

Yes|No

Yes

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

Yes|No

Yes

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

Yes|No

Yes

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

Yes|No

Yes

Check this option if you wish to create the target table.

Yes|No

Yes

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

XREF table name

Yes

Table Name to use in the XREF table. Example: ORDERS

Coumn name

Yes

Primary key column name to use as a literal in the XREF table

ODI

Yes

Last Accessed literal to use in the XREF table.

See the LKM SQL to SQL (ESB XREF) section above for details on the LKM MSSQL to SQL (ESB XREF) options.

IKM SQL Control Append (ESB XREF)

Option

INSERT

Yes

Enter the expression used to populate the common ID for the XREF table (column name "VALUE"). Valid examples are: SYS_GUID(), MY_SEQUENCE.NEXTVAL, etc.

COMMIT

FLOW_CONTROL

RECYCLE ERRORS

_

STATIC CONTROL

_

TRUNCATE

DELETE_TEMPORARY _OBJECTS

DELETE_ALL

CREATE TARG TABL E _ _

X R E F _ T A B L E _ N A M E

X R E F _ S Y S _ G U I D _ PRESSION E X

SYS GUID()

_

XREF COLUMN NAM E _ _

X R E F _ L A S T _ A C C E S ED S

Knowledge Modules Reference Guide

67/131

Document info
Document views437
Page views440
Page last viewedSun Dec 11 10:39:05 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments