Sunday, 15 June 2014

Understanding Interface Quick Edit objects in Interface in ODI 11G?



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