Exception to Recommended Parameter Settings

An exception to using the recommended parameter settings is when you want to update the primary foreign key columns in the parent table. In this case, you do not want to include the following parameter in the EIM configuration file:

UPDATE ROWS = parent_table, FALSE

For example, EIM_ACCOUNT1 maps to the user key columns of S_ORG_EXT only. You can use EIM_ACCOUNT1 to update the primary foreign keys in S_ORG_EXT if the explicit primary mappings exist, such as S_ORG_EXT.PR_INDUST_ID, in the explicit primary mapping contained in the table mapping of S_ORG_INDUST. For more information, see About Explicit Primary Mappings.

In this case, you should use the default setting, UPDATE ROWS = S_ORG_EXT, TRUE in the EIM configuration file. If you do not need to update primary foreign keys in S_ORG_EXT, then you should set UPDATE ROWS = S_ORG_EXT, FALSE in the EIM configuration file.