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 / 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
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is meant by a Highest Cost Plan?
What are the various indexes in teradata? How to use them?
List out all forms of LOCKS that are available in Teradata.
What is the function of parser component in teradata?
What is dimensional modeling?
If a Node is busy what are the steps you can take to avoid ?
What do you mean by tpt in teradata?
What are different table types used in teradata?
How do you define Teradata?
What are the different methods ot loading a dimension table? A fact table etc?
Why managing the data is important?
What are the steps involved after the disk manager passes the request?
Highlight the differences between Primary Key and Primary Index.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
