IM and MDIS Import more records than DM shows
[2790606] [CSN] [MDIS] [mdis blackboard] [mdis singapore] [records]
Symptom
After importing 3000 records into an empty MDM main table, only 2969 records appear in the Data Manager when looking at the main table.
Other terms
CSN 2790606
Reason and Prerequisites
Import Manager and Import Server actually import 2969 records from the source file although they both declared to import 3000 records. Import Manager has 3000 in the Default Import Action and Import Server log file declared that “Import action: Create: 3000″
Solution
This is MDM Import (Import Manager and Import Server) correct behavior.
The import tool shows a greater number of records since finding duplicated records is preformed only when the Import process is actually executed and its embedded within the import process in run-time. (To find the duplicated record you can import the source file into MS-Accesses.)
In [...]