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...

plz explain parlla distribution and subtable concept in teradata

Answer Posted / yuvaevergreen

Parallel distribution: TD stores the data uniformly. Ideally, every amp should have equal no of rows from each table in vdisks.Based on the primary index, the distribution of data would be uniform on amps.

Sub table: It is used for secondary indexes and stored in amp(s).

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is node? How many nodes and amps used in your previous project?

1153


What is the use of teradata system software?

1087


How will you solve the problem that occurs during update?

1104


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2261


Why are oltp database designs not generally a good idea for a data warehouse?

1103


What is a clique?

1152


Explain the term 'primary key' related to relational database management system?

1088


In BTEQ, how are the session-mode parameters being set?

1189


why use references rather than pointers in the public api, particularly for arguments which are modified?

1052


List out some of the primary characteristics of teradata.

1060


What is the difference between teradata and basic rdbms?

1072


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

1208


What is dimensional modeling?

1138


What is upsert statement in teradata?

1190


What is the use of having index on table?

1040