Answer Posted / yuvaevergreen
Adding to the above, the work tables are created in
permanent space and used by the amps. Be aware of the
estimated perm space so that mload performance would be good.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Difference between stored procedure and macro?
Highlight the points of differences between the database and user in Teradata.
Highlight the need for Performance Tuning.
Differentiate database data and data warehouse data?
What is TPD?
Name the five phases that come under MultiLoad Utility.
What is the multi-insert?
How to load specific no.of records using bteq, or fastload,or multiload
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain teradata architecture in detail with a diagram.
What are the functions involved in shared information architecture?
What is the purpose of joins in teradata and what are the available join types?
What are the joins in teradata and how many types of joins are there in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What do you mean by teradata intellicloud?