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


Please Help Members By Posting Answers For Below Questions

List out teradata data types?

566


What are the functions of a teradata dba?

604


Mention a few of the ETL tools that come under Teradata.

630


What is teradata? What are some primary characteristics of teradata?

557


What are the components used in smp and massively parallel processing (mpp) machines?

618






Explain the parallel data extension in teradata?

665


What is multi insert?

634


How to Extract data from multiple legacy systems?

584


What is the difference between teradata and basic rdbms?

576


What is the purpose of upsert command?

599


Differentiate primary key and partition key?

590


Difference between multiload and tpump?

627


What are the various indexes in teradata? How to use them?

576


How is MLOAD Client System restarted after execution?

610


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

644