What Will Happen After Processing If There Were Two Duplicate Records

1.	What Will Happen After Processing If There Were Two Duplicate Records In The Eim Table?
Answer» EIM PROCESSES a record once for each batch, so for each record, MIN(ROW_ID) is PROCESSED, and the other record is marked as a duplicate i.e. IF_ROW_STAT is set to DUP_RECORD_IN_EIM_TBL for the duplicate record. If you ENTER the user key of a record with DIFFERENT attributes twice in the EIM table, only the record with the MIN(ROW_ID) will be imported or updated. The duplicate will be ignored. EIM processes a record once for each batch, so for each record, MIN(ROW_ID) is processed, and the other record is marked as a duplicate i.e. IF_ROW_STAT is set to DUP_RECORD_IN_EIM_TBL for the duplicate record. If you enter the user key of a record with different attributes twice in the EIM table, only the record with the MIN(ROW_ID) will be imported or updated. The duplicate will be ignored.

What Will Happen After Processing If There Were Two Duplicate Records In The Eim Table?

Answer»

EIM PROCESSES a record once for each batch, so for each record, MIN(ROW_ID) is PROCESSED, and the other record is marked as a duplicate i.e. IF_ROW_STAT is set to DUP_RECORD_IN_EIM_TBL for the duplicate record. If you ENTER the user key of a record with DIFFERENT attributes twice in the EIM table, only the record with the MIN(ROW_ID) will be imported or updated. The duplicate will be ignored.

EIM processes a record once for each batch, so for each record, MIN(ROW_ID) is processed, and the other record is marked as a duplicate i.e. IF_ROW_STAT is set to DUP_RECORD_IN_EIM_TBL for the duplicate record. If you enter the user key of a record with different attributes twice in the EIM table, only the record with the MIN(ROW_ID) will be imported or updated. The duplicate will be ignored.

Discussion

No Comment Found

Related InterviewSolutions

What Will Happen After Processing If There Were Two Duplicate Records In The Eim Table?
Can You Enumerate The 11 Steps For Eim Import Process?
What Is The Difference Between Default Column And Fixed Column Parameters?
Why Using Synonyms = False Parameter Is Highly Recommended For Eim Performance Tuning?
What Is The Purpose Of Session Sql Parameter In The Ifb File?
What Does Include Parameter Mean In An Ifb File?
In The Ifb File, You Have Mentioned The Credentials For Database Incorrectly But The Proper Credentials Are Stored At Srvmgr Level, Will The Job Throw Any Error?
What Is The Difference Between If_row_stat And If_row_stat_num Columns?
How Will You Identify The Corresponding Eim Column For A Particular Base Table Column? Say For S_prod_int.name, Explains?
Explicit Primary Mapping Does Not Occur In Each Eim Table Mapping. In Which Case Can You Find The Explicit Primary Mapping Defined In The Eim Table Mapping?