Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 9617 Views
- TCS, I also Faced
- E-Mail Answers
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
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What are normalization, first normal form, second normal form and third normal form?
What is real time and near real time data warehousing?
What are the various indexes in teradata? How to use them?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
In Teradata, what is the significance of UPSERT command?
What interface is used to connect to windows based applications?
During the Display time, how is the sequence generated by Teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What are the different functions included in the server software?
What do you mean by caching in teradata?
What is the command in bteq to check for session settings ?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Explain amp in teradata?
What is meant by a Highest Cost Plan?
