Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 47099 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
Explain the teradata primary index mechanics in detail with a diagram.
What are the different table types supported by teradata?
Describe the set operators in teradata.
Explain teradata architecture in detail with a diagram.
How do you define Teradata?
What are aggregate tables? How do you design them using teradata?
Explain Teradata performance tuning and optimization?
What are the things to be considered while creating secondary index?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Difference between stored procedure and macro?
What is teradata? What are some primary characteristics of teradata?
What is the difference between teradata and basic rdbms?
Is multi insert ansi standard?
What are the different design perspectives used in teradata?
If RDBMS is halted what will you do ?
