How can we set Primaries(Explicit) using EIM.

Siebel EIM populates primary foreign keys through the use of explicit primary mapping. When importing MVG records through Siebel EIM a column exists in the EIM table which can be used to flag the record as a primary MVG record. This is called an explicit primary mapping. However if you do not explicitly flag an MVG as primary the MVG records will still import and will not be flagged as primary. This is called implicit primary mapping

Give the miscellaneous sql parameter in the ifb file for the corresponding column as explicit primary and upload the corresponding EIM table column for explicit primary as y for the record you have set it to primary
eg.
MISC SQL = EXPR_FINS_S_ORG_EXT_PR_BL_PER_ID

In case you have to use implicit mapping

give
MISC SQL=IMPR_FINS_S_ORG_EXT_PR_BL_PER_ID
in the IFB file

Pls Note: This will mark implicit primary for the mvg field and it will ignore the values you set as explicit primary.


In case you have to use implicit and explicit primary, ie if in case explicit primary is given, it should use explicit primary or if no primary is set, it should use implicit primary. In that case,
give

MISC SQL=EXPR_FINS_S_ORG_EXT_PR_BL_PER_ID,IMPR_FINS_S_ORG_EXT_PR_BL_
PER_ID

in the IFB file