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
In BTEQ, how are the session-mode parameters being set?
What is the use of teradata system software?
What are the different design perspectives used in teradata?
How is MLOAD Client System restarted after execution?
What is multi insert?
What do you mean by tpt in teradata?
What is the basic syntax for teradata select statement?
In Teradata, what is the significance of UPSERT command?
Highlight the need for Performance Tuning.
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
What are the different softwares used with their functions in teradata?
What are the uses of bynets in multi-node systems?
What are the various indexes in teradata? How to use them? Why are they preferred?
Explain how spool space is used.
What are the functions of a teradata dba?