ODI Interface Mapping Quick Edit All The fields information

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.

Loading (LKM)

All active mapping expressions that are executed in the current source set, as well as all the columns from the current source set used in the mapping, filters and joins expressions executed in the staging area appear in this list. The list is sorted by POS, FILE_POS.
If there is a journalized datastore in the source of the interface, the three journalizing pseudo columns JRN_FLAG, JRN_DATE, and JRN_SUBSCRIBER are added as columns of the journalized source datastore.

Integration (IKM)

All current active mapping expressionsin the current interface appear in the list.
The list contains one element for each column that is loaded in the target table of the current interface. The list is sorted by POS, FILE_POS, except when the target table is temporary. In this case it is not sorted.
If there is a journalized datastore in the source of the interface, and it is located in the staging area, the three journalizing pseudo columns JRN_FLG, JRN_DATE,and JRN_SUBSCRIBER are added as columns of the journalized source datastore.

Check (CKM)

All the columns of the target table (with static or flow control) appear in this list.
To distinguish columns mapped in the current interface, you must use the MAP selector.