What is the diffrence between Multiload & Fastload interms
of Performance?
Answer Posted / kumar
Multiload can at max 5 tables with non unique secondary
indexes on them. where as in fastload u cannot have
secondary indexes on the table.
In multiload you can insert,update or delete data in
already populated tables whereas in fastload the target
table should be empty.
Multiload works in 5 phases whereas fastload works in two
phases.
If we want to load data into an empty table then fastload
is best option as compared to multiload.
Is This Answer Correct ? | 54 Yes | 6 No |
Post New Answer View All Answers
Why is the case expression used in teradata?
What are the uses of bynets in multi-node systems?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Can we collect statistics on table level?
What are the enhanced features in teradata v2r5 and v2r6?
What are the functions involved in shared information architecture?
What is a level of granularity of a fact table?
Explain and compare pros and cons of snow flake schemas?
Explain Teradata performance tuning and optimization?
What is the difference between teradata and oracle?
How many types of joins are there in teradata?
what are the uses of fact table and dimension table in banking project?
Name the five phases that come under MultiLoad Utility.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Syntax for case when statement?