Missing record on loading table with Fastload

Database
Enthusiast

Missing record on loading table with Fastload

Hi,

I have a .txt file which is pipe separated and it has 543895 rows. Duplicate records are avoided by putting a serial number at the end of every row.

Its UTF-8 encoded. On running the fastload script, I had got the error ": EOF encountered before end of record" and on reading another post in this forum I added a new line at the end of my last record, after which the fastload script was running fine. But one of my records is not loaded into table, since it was found to be a duplicate record.

 Total Records Read              =  543895

     Total Error Table 1             =  0  ---- Table has been dropped

     Total Error Table 2             =  0  ---- Table has been dropped

     Total Inserts Applied           =  543894

     Total Duplicate Rows            =  1

But I fail to understand how a duplicate record can be found despite adding a unique serial number at the end of every row.

If any one of you could please help, I'd be much obliged.

Thanks,

anju

1 REPLY
Senior Supporter

Re: Missing record on loading table with Fastload

What you descriped is indicating that the serial number process has one dup value.

Can you share the file?