Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8118 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Explain BYNET.
how many modules are there in telecome domain?how to explain the architecture?
what are the uses of fact table and dimension table in banking project?
What is oltp?
What is a sparse index?
Syntax for case when statement?
What are the various indexes in teradata? How to use them?
How to Extract data from multiple legacy systems?
What are the different softwares used with their functions in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Explain the parallel data extension in teradata?
Explain the term 'columns' related to relational database management system?
What is TPD?
What are the enhanced features in teradata v2r5 and v2r6?
