Answer Posted / rajneesh
FastLoad support Multiset table but does not support the
duplicate rows.
Multiset tables are tables that allow duplicate rows.
When FastLoad finds the duplicate rows it discards it. Fast
Load can load data into multiset table but will not load
the duplicate rows.
| Is This Answer Correct ? | 30 Yes | 3 No |
Post New Answer View All Answers
What type of indexing mechanism do we need to use for a typical data warehouse?
How is the teradata different from oracle?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are differences between teradata and ansi session modes in teradata?
What is database exceptions in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain Teradata performance tuning and optimization?
What is meant by a Highest Cost Plan?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Explain the types of join supports by teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Highlight the need for Performance Tuning.
Why teradata is used?
