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