What is the diffrence between Multiload & Fastload interms
of Performance?
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
Difference between inner join and outer join?
How do you define Teradata?
What are the steps to create a data model?
How do you see a ddl for an existing table?
What is the command in bteq to check for session settings ?
Explain teradata utilities?
Highlight all the modes that are present under Confidence Level.
What are the joins in teradata and how many types of joins are there in teradata?
How many types of joins are there in teradata?
What are default access rights in teradata?
What is inner join and outer join?
What is the function of parser component in teradata?
What is a clique?
What are the commands to make a new table, change a table and remove a table in teradata?
How can we check the version of Teradata that we are using currently?