What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 45825 Views
- Cap Gemini, Intel, I also Faced
- E-Mail Answers
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
What's the difference between timestamp (0) and timestamp (6)?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the functions of a Parser?
What do you mean by ttu in teradata?
What is the purpose of indexes?
What are the different methods ot loading a dimension table? A fact table etc?
Explain and compare pros and cons of start schemas?
What type of indexing mechanism do we need to use for a typical data warehouse?
What do high confidence, low confidence and no confidence mean in explain plan?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Highlight the points of differences between the database and user in Teradata.
How many sessions of MAX is PE capable of handling at a particular time?
Explain PDE.
How to find duplicates in a table?
What tools would you use for that?
