INTERFACE QUICK EDIT
Components List
Parameter Value
Description
INS
LKM: Not applicable (*)
IKM: Only for mapping expressions marked
with insertion
CKM: Not applicable
UPD
LKM: Not applicable (*)
IKM: Only for mapping expressions marked
with update
CKM: Not applicable
TRG
LKM: Not applicable (*)
IKM: Only for mapping expressions executed
on the target
CKM: Not applicable
NULL
LKM: Not applicable (*)
IKM: All mapping expressions loading not
nullable columns
CKM: All target columns that do not accept
null values
PK
LKM: Not applicable (*)
IKM: All mapping expressions loading the
primary key columns
CKM: All the target columns that are part
of the primary key
UK
LKM: Not applicable (*)
IKM: All the mapping expressions loading
the update key column chosen for the current interface
CKM: Not applicable
REW
LKM: Not applicable (*)
IKM: All the mapping expressions loading
the columns with read only flag not selected
CKM: All the target columns with read only
flag not selected
UD1
LKM: Not applicable (*)
IKM: All mapping expressions loading the
columns marked UD1
CKM: Not applicable
UD2
LKM: Not applicable (*)
IKM: All mapping expressions loading the
columns marked UD2
CKM: Not applicable
UD3
LKM: Not applicable (*)
IKM: All mapping expressions loading the
columns marked UD3
CKM: Not applicable
UD4
LKM: Not applicable (*)
IKM: All mapping expressions loading the
columns marked UD4
CKM: Not applicable
UD5
LKM: Not applicable (*)
IKM: All mapping expressions loading the
columns marked UD5
CKM: Not applicable
MAP
LKM: Not applicable
IKM: Not applicable
CKM:
Flow
control: All columns of the target table loaded with expressions in the current
interface
Static
control: All columns of the target table
SCD_SK LKM, CKM, IKM: All columns marked
SCD Behavior: Surrogate Key in the data model definition.
SCD_NK LKM, CKM, IKM: All columns marked
SCD Behavior: Natural Key in the data model definition.
SCD_UPD LKM, CKM, IKM: All columns marked SCD
Behavior: Overwrite on Change in the data model definition.
SCD_INS LKM, CKM, IKM: All columns marked
SCD Behavior: Add Row on Change in the data model definition.
SCD_FLAG LKM, CKM, IKM: All columns marked SCD
Behavior: Current Record Flag in the data model definition.
SCD_START LKM, CKM, IKM: All columns marked SCD
Behavior: Starting Timestamp in the data model definition.
SCD_END LKM, CKM, IKM: All columns marked
SCD Behavior: Ending Timestamp in the data model definition.
NEW Actions: the column added to a table, the
new version of the modified column of a table.
OLD Actions: The column dropped from a table,
the old version of the modified column of a table.
WS_INS SKM: The column is flagged as
allowing INSERT using Data Services.
WS_UPD SKM: The column is flagged as
allowing UDATE using Data Services.
WS_SEL SKM: The column is flagged as
allowing SELECT using Data Services.
No comments:
Post a Comment