|
|
|
Junior Member
 
Group: Forum Members
Last Login: 10/27/2009 10:22:36 AM
Posts: 17,
Visits: 18
|
|
Can someone explain this, since I don't understand what is happening. My MLoad runs to a good completion code. However, my question is about the number of records read in, compared to the number inserted.
Records read = Records that satisfy the conditions. However, the records inserted does not equal these numbers. Why? There are no UV or ET records written, so I am confused why the number inserted is not the same as the records that satisfied conditions.
Here are the stats from the log file:
. IMPORT 1 Total thus far
. ========= ==============
Candidate records considered:........4662284....... 4662284
Apply conditions satisfied:.......... 4662284....... 4662284
Candidate records not applied:....... 0....... 0
Candidate records rejected:.......... 0....... 0
-----------------------------------------------------------------------------------------------
Inserts: 4624210
Updates: 0
Deletes: 0
============== ========================================================
0 TDWWorkTbls.ET_IMFStage
0 TDWWorkTbls.UV_IMFStage
Thanks!
Paul
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/27/2009 10:22:36 AM
Posts: 17,
Visits: 18
|
|
Never mind.....I found a "Ignore Duplicates" command in the MLoad, so that would explain the difference I saw in the numbers without any UV record count.
Sorry for the confusion.
Paul
|
|
|
|