X hits on this document

315 views

0 shares

1 downloads

0 comments

66 / 131

SRC_PK_LOGICAL _SCHEMA

Name of source table’s logical schema

No

Indicates the source table's logical schema. The source table is the one from which we want to delete or update records after processing them. This logical schema is used to resolve the actual physical schema at runtime depending on the Context. Example: ORDER_BOOKING This option is required only when SRC_UPDATE_DELETE_ACTION is set to UPDATE

or DELETE.

S R C _ P K _ T A B L E _ AME N

Source table name, default is MY_TABLE

No

Indicate the source table name of which we want to delete records after processing them. Example: ORDERS This option is required only when SRC_UPDATE_DELETE_ACTION is set to UPDATE or DELETE.

SRC_PK_TABLE_A LIAS

Source table alias, default is

MY_ALIAS

No

Indicate the source table's alias within this interface. The source table is the one from which we want to delete or update records after processing them. Example: ORD This option is required only when SRC_UPDATE_DELETE_ACTION is set to UPDATE

or DELETE.

SRC UPD COL

_

_

Aliased source column name

No

Aliased source column name that holds the update flag indicator. The value of this column will be updated after integration when SRC_UPDATE_DELETE_ACTION is set to UPDATE with the expression literal SRC_UPD_EXPRESSION. The alias used for the column should match the one defined for the source table. Example: ORD.LOADED_FLAG This option is required only when SRC_UPDATE_DELETE_ACTION is set to UPDATE.

No

Literal or expression used to update the SRC_UPD_COL. This value will be used to update this column after integration when SRC_UPDATE_DELETE_ACTION is set to UPDATE. Example: RECORDS PROCESSED This option is required only when SRC_UPDATE_DELETE_ACTION is set to UPDATE.

Yes

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

DELETE_TEMPOR ARY_OBJECTS

Yes|No

_ SRC_UPD EXPRE

Literal or

SSION

expression

LKM MSSQL to SQL (ESB XREF)

Knowledge Modules Reference Guide

66/131

Document info
Document views315
Page views318
Page last viewedSat Dec 03 00:51:25 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments