Can You Enumerate The 11 Steps For Eim Import Process?

1.	Can You Enumerate The 11 Steps For Eim Import Process?
Answer» EIM INITIALIZES any temporary columns. EIM applies any DEFAULT_COLUMN and FIXED_COLUMN values defined for the import PROCESS. EIM applies any filter queries defined for the import process. EIM generates foreign key references for rows with corresponding existing rows in the Siebel base tables. EIM writes the appropriate ROW_ID values in the EIM table rows’ temporary columns, for rows with corresponding base table rows. EIM creates a ROW_ID with a unique value in the base table for each EIM table row without a corresponding row in the base tables. EIM eliminates rows with invalid values for user keys from further processing. EIM UPDATES contents of existing base table rows with contents from corresponding EIM table rows that have successfully passed all earlier steps. EIM inserts any new EIM table rows that have successfully passed all earlier steps in the Siebel database tables. EIM updates primary child relationships in the Siebel database tables as necessary. Finally, EIM runs optional miscellaneous SQL STATEMENTS.

Answer»

EIM INITIALIZES any temporary columns.
EIM applies any DEFAULT_COLUMN and FIXED_COLUMN values defined for the import PROCESS.
EIM applies any filter queries defined for the import process.
EIM generates foreign key references for rows with corresponding existing rows in the Siebel base tables.
EIM writes the appropriate ROW_ID values in the EIM table rows’ temporary columns, for rows with corresponding base table rows.
EIM creates a ROW_ID with a unique value in the base table for each EIM table row without a corresponding row in the base tables.
EIM eliminates rows with invalid values for user keys from further processing.
EIM UPDATES contents of existing base table rows with contents from corresponding EIM table rows that have successfully passed all earlier steps.
EIM inserts any new EIM table rows that have successfully passed all earlier steps in the Siebel database tables.
EIM updates primary child relationships in the Siebel database tables as necessary.
Finally, EIM runs optional miscellaneous SQL STATEMENTS.

Discussion