Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 47813 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
What is a clique?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What do you mean by tpt in teradata?
What are the scenarios in which full table scans occurs?
How many tables can you join in v2r5?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is the use of fallback?
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?
How do you see a ddl for an existing table?
Difference between star and snowflake schemas?
Highlight all the modes that are present under Confidence Level.
what is sysdba and sysdbc ? which has high priority ?
What are the advantages of teradata?
Highlight the need for Performance Tuning.
Explain fallback in teradata?
