Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 47163 Views
- Cap Gemini, Intel, I also Faced
- E-Mail Answers
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
Highlight the advantages of PPI(Partition Primary Index).
What do you mean by tpt in teradata?
Why managing the data is important?
Explain the term 'foreign key' related to relational database management system?
What are the different softwares used with their functions in teradata?
Explain the term 'primary key' related to relational database management system?
What is database exceptions in teradata?
How to find duplicates in a table?
Why do you get spool space errors? How do trouble-shoot them?
What is meant by Teradata Gateway?
What do you mean by ttu in teradata?
What tools would you use for that?
What is the maximum number of dml can be coded in a multiload script?
Which is faster fastload or multiload?
How is MLOAD Client System restarted after execution?
