What is the diffrence between Multiload & Fastload interms
of Performance?
Answer Posted / gaurav
Fast load v/s Multi Load
1) FL insert data into empty table ML insert/update/delete
data in populated tables
2) FL one table ML upto 5 tables.
3) FL loads into empty table ML loads into Populated table.
4) FL no SI allowed in ML NUSI is allowed.
5) FL is 2 step ML is 5 step.
6) FL no multiset tables allowed ML multiset table is allowed.
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What is the multi-insert?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Highlight the differences between Primary Key and Primary Index.
What is a node in teradata? Explain
Difference between multiload and tpump?
What is the function of parser component in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What's the difference between timestamp (0) and timestamp (6)?
What is the use of virtual processor connectivity in teradata?
Which is more efficient group by or distinct to find duplicates?
What are the design features involved in teradata?
What do you mean by tpt in teradata?
Explain fastload in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What exactly do you know about catching in teradata?