What is the diffrence between Multiload & Fastload interms
of Performance?
Answer Posted / kumar
Multiload can at max 5 tables with non unique secondary
indexes on them. where as in fastload u cannot have
secondary indexes on the table.
In multiload you can insert,update or delete data in
already populated tables whereas in fastload the target
table should be empty.
Multiload works in 5 phases whereas fastload works in two
phases.
If we want to load data into an empty table then fastload
is best option as compared to multiload.
Is This Answer Correct ? | 54 Yes | 6 No |
Post New Answer View All Answers
How do you verify a complicated sql?
List out some of the primary characteristics of teradata.
What are different table types used in teradata?
In general, how do you optimze any sql in teradata?
How to find duplicates in a table?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are the various indexes in teradata? Why are they preferred?
What is called partitioned primary index (ppi)?
Describe the set operators in teradata.
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Explain fallback in teradata?
What is the syntax for case when statement?
Why does varchar occupy 2 extra bytes?
What is a clique?
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?