Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8156 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yogi
PI determines the distribution and retrieval of data for a
table in TD. If a primary index is not defined, either a PK
or Unique key or first column is assigned to be a PI. PI is
mandatory in TD.
PPI is used to store the data in partition. Along with the
row hash value, partition numbers are also stored.
While creating the table, PARTITION BY clause is used to
partition the data. Either RANGE_N or CASE_N can be used.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / tdguy
PI is mandatory in TD. Data distribution in TD depends on
PI. The PI more unique, more will be the performance. PPI
is generally used for range processing.TD stores data
within a block based on row id. But PPI stores the rows in
a data block by the value instead of the ROWID. Therefore,
range processing will be faster.
partition by statement is used along with create statement.
range for weeks or months or days can be mentioned by using
interval option.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
How many types of joins are there in teradata?
What do you mean by teradata intellicloud?
What is the difference between teradata and oracle?
Can any one plz provide the teradata interview questions?
Which is more efficient group by or distinct to find duplicates?
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Give some points about Teradata Viewpoint ?
Define views in teradata with syntax.
Teradata 
