Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4375


if collect stats but it show low confidence why?

1691


What is spool space? Why do you get spool space errors?

1023


What are the uses of client software involved in teradata?

984


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1099


What are the components provided on node?

1048


Explain the types of join supports by teradata?

995


During the Display time, how is the sequence generated by Teradata?

1059


What is the basic syntax for teradata select statement?

1049


What are the functions of a teradata dba?

1078


What is the difference between teradata and oracle?

1029


What is meant by a Channel Driver?

1250


Explain teradata architecture in detail with a diagram.

1115


What is teradata? Also, list out some of the primary characteristics of teradata.

1061


What does Amp contain and what are all the operations that it performs?

1007