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
Different phases of multiload?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the design features involved in teradata?
What are the steps involved after the disk manager passes the request?
Explain the parallel data extension in teradata?
List out teradata data types?
Describe primary index in teradata. And what are the available primary index types?
In general, how do you optimze any sql in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
List the logical and conditional operators that are used with teradata along with their meanings?
What is real time and near real time data warehousing?
What is the basic syntax for teradata select statement?
What do you mean by fastexport in teradata?
How do you determine the number of sessions?
How is MLOAD Teradata Server restarted after execution?