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
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?
What is spool space?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What do you mean by ttu in teradata?
Explain vproc in teradata?
What is the purpose of indexes?
What are the 5 phases in a multiload utility?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What do you mean by teradata intelliflex?
How is the teradata different from oracle?
What are teradata utilities?
What are the functions of a Parser?
Explain the term 'foreign key' related to relational database management system?
What are aggregate tables? How do you design them using teradata?
how do you manage the production space. what are the proactive methods you can take ?