Tuesday, December 15, 2009

EIM uses temporary columns to manipulate data during processing

EIM uses temporary columns to manipulate data during processing. For example, EIM might store the ROW_ID value for a Siebel base table in a temporary column. These column names begin with T_ and indicate the table or column for which they are used. Because EIM uses these columns internally during processing, do not manipulate these columns in the EIM tables.
 
Each EIM table has three processing columns at the EIM table level:
1)      T_DELETED_ROW_ID Deleted ROW_ID from the Base Table.
2)      T_EXPORTED_ROW_ID Exported ROW_ID from Target Table.
3)      T_MERGED_ROW_ID  Merged into ROW_ID from Target Table.
Four processing columns for each table mapping:
1)      Name : T_XXX_RID,  Type: IFMGR: ROW_ID
2)      Name : T_XXX_EXS, Type: IFMGR :Exists
3)      Name : T_XXX_STA, Type : IFMGR : Status
4)      Name : T_XXX_UNQ,Type : IFMGR: Unique
 
One processing column for each foreign key mapping (Name: T_XXX_BU_ID, Type: IFMGR: Fkey.


http://www.siebeldigest.com/

1 comments:

Rajkumar Raju said...

The column name would be T_XXXX__RID . It does has two 'underscore's.. Please check..