Interested to Buy Any Domain ? << Click Here >> for more details...
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
what are the day to day activities of teradata DBA ?
What are default access rights in teradata? What explicit right can be given to a user?
What is the purpose of upsert command?
Syntax for case when statement?
What is spool space? Why do you get spool space errors?
What are the steps involved in the process flow of the sql statement through channel attached system?
What type of indexing mechanism do we need to use for a typical data warehouse?
How to load specific no.of records using bteq, or fastload,or multiload
What are the 5 phases in a multiload utility?
What happens in a conflict? How do you handle that?
What is the command in bteq to check for session settings ?
How do you verify a complicated sql?
What are the various indexes in teradata? Why are they preferred?
How do you set the session mode parameters in bteq?
What do you mean by teradata intellicloud?
