What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 7390 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
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How to eliminate product joins in a teradata sql query?
Explain teradata architecture in detail with a diagram.
Explain fastload in teradata?
What is spool space? Why do you get spool space errors?
What is bteq script in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Highlight the points of differences between the database and user in Teradata.
What is the difference between fastload and multiload?
Explain the term 'primary key' related to relational database management system?
What is TPD?
What are some commonly used bteq scripts?
How can bottlenecks be identified?
Highlight a few of the advantages that ETL tools have over Teradata.
What is the purpose of joins in teradata and what are the available join types?
