MLoad Question

Tools & Utilities
Teradata Employee

MLoad Question

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
1 REPLY
Teradata Employee

Re: MLoad Question

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