Interview Questions   Tutorials   Discussions   Programs   

Teradata - Can we load a Multi set table using MLOAD?

asked mar September 20, 2014 06:38 AM  

Can we load a Multi set table using MLOAD?


1 Answers

answered By vishnoiprem   0  
YES, We can Load SET, MULTISET tables using Mload, But here when loading into MULTISET table using MLOAD duplicate rows will not be rejected, we have to take care of them before loading.

But in case of Fload when we are loading into MULTISET duplicate rows are automatically rejected, FLOAD will not load duplicate rows weather table is SET or MULTISET
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!