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 managing the data is important?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
How do you determine the number of sessions?
In Teradata, what is the significance of UPSERT command?
Why are oltp database designs not generally a good idea for a data warehouse?
Why teradata is used?
Syntax for case when statement?
Name the five phases that come under MultiLoad Utility.
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is TPD?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Explain teradata utilities. What is multiload, fast load, tpump?
What tools would you use for that?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are types of partition primary index (ppi) in teradata?