Where we use PPI in real time??? What is the disadvantages
of PPI?
Answer Posted / yuvaevergreen
Disadv: Joins to Non-Partitioned Tables can take longer.
Additional overhead of two-byte Partition number.
Is This Answer Correct ? | 2 Yes | 1 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 the syntax for case when statement?
In BTEQ, how are the session-mode parameters being set?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What do you mean by tpt in teradata?
Why is the case expression used in teradata?
What is partitioned primary index (ppi)?
Explain the types of join supports by teradata?
What are the multiload utility limitations?
Explain the term 'database' related to relational database management system?
Explain Teradata performance tuning and optimization?
Discuss the advantages of using partitioned primary index in a query?
Explain the most common data types used in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the various etl tools in the market?