Answer Posted / sat!sh
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 incase 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
----
Hi Friends Got a Best ANS share with us :)
| Is This Answer Correct ? | 35 Yes | 1 No |
Post New Answer View All Answers
Explain how spool space is used.
Differentiate database data and data warehouse data?
Explain the term 'primary key' related to relational database management system?
What are differences between teradata and ansi session modes in teradata?
What is oltp?
What is the difference between teradata and oracle?
What is stored procedure in teradata?
Why does varchar occupy 2 extra bytes?
What are the different functions performed in development phase?
In BTEQ, how are the session-mode parameters being set?
What's the difference between timestamp (0) and timestamp (6)?
How to identify ppi columns?
Explain and compare pros and cons of start schemas?
Explain the types of join supports by teradata?
What is the maximum number of dml can be coded in a multiload script?