Duplicate rows in MLoad?

Tools & Utilities
Enthusiast

Duplicate rows in MLoad?

Does Mload support loading duplicate rows? If yes how does it handle loading the duplicate rows after a failure(While restarting the same MLoad job again)?

Tags (3)
9 REPLIES
Enthusiast

Re: Duplicate rows in MLoad?

Yes, MLOAD supports the insertion of deuplicate records and this is the main difference between the FASTLOAD and MULTILOAD.

The below thread should give you more details...

http://forums.teradata.com/forum/general/mload-vs-fastload-in-rejecting-the-duplicates

Enthusiast

Re: Duplicate rows in MLoad?

Thanks Qaisar :) Thats what i exactly wanted to know...

Highlighted
Junior Supporter

Re: Duplicate rows in MLoad?

That's not totally correct.

Fastload allows duplicate rows if loading into NOPI tables.

Cheers.

Carlos.

Enthusiast

Re: Duplicate rows in MLoad?

Absolutely correct, if the table is NOPI then fastload shouldn't have any issue loading the duplicates...

Enthusiast

Re: Duplicate rows in MLoad?

Guys can you pls shed some more light on how Fastload handles duplicate rows in NOPI tables in case of a restart.

Re: Duplicate rows in MLoad?

Hi All,

As Multiload  handles duplicates then if have update statement and finds multiples rows to update then multiload updates which row?.

Enthusiast

Re: Duplicate rows in MLoad?

Hi barani_sachin,

NOPI tables are inherently MULTISET, and because the row distribution is not based on any index they so it is possible that they can reside on a different AMP so duplicate row checking is not possible. So when the FastLoad targets a a NOPI table, no check is made for duplicate rows and are not discarded!

Regards,

Enthusiast

Re: Duplicate rows in MLoad?

Hi raghu45,

All the duplicate rows will be updated because thats what you asked for in the SQL.

Regards,

Enthusiast

Re: Duplicate rows in MLoad?

Thanks Qaisar... Now i got that Fload will insert duplicate rows in NOPI tables. How does it handle that when there is some interuption and after that the Fload is restarted?