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 / karthik

parlla distribution:
This is the key concept of Teradata storing data in parallel, as it uses PI to store data, data is is stored parallel across the AMP's available.

Sub table: This table is created when a Unique secondary Index is created on the table, it will have rowid,data and hash value for the data. It is used to fetch the data using secondary index.

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of bynets in multi-node systems?

979


Explain how spool space is used.

1033


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

1055


What is the purpose of joins in teradata?

1090


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2374


Why managing the data is important?

974


How do you do backup and recovery in teradata?

973


What is the purpose of indexes?

1023


How is the teradata different from oracle?

1050


When tpump is used instead of multiload?

1061


What are teradata utilities?

1050


What are the available primary index types in teradata.

994


Give a justifiable reason why Multi-load supports NUSI instead of USI.

1099


How to Extract data from multiple legacy systems?

1055


What are the various indexes in teradata?

990