What is Difference b/w PI & PPI?how to implement PPI?
Answer Posted / yuvaevergreen
PI is used for creating hash values and in turn, affects the
distribution of the rows across the amps. PPI is used to
partition the rows based on range of values. PPI is not
mandatory whereas PI is mandatory. PPI is generally used for
enhanced range processing. PPI can be used to avoid FTS,
thereby increasing the performance.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you create tables? Exact syntax, and create profiles, users in teradata?
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?
What is meant by a Clique?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is spool space?
How you will check the version of teradata?
Explain teradata utilities?
What is teradata?
Highlight a few of the important components of Teradata?
what is object level locking ? where do appear this type of locking ?
What are default access rights in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
How can you track login parameters of users in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
Steps to create a data model?