Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary index and secondary index?.
- 2 Answers
- 8682 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
Distribution of data in TD depends on primary index. SI is not involved in distribution of data. PI is mandatory whereas SI is optional. SI, if not chosen properly, is just an overhead.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / tdguy
PI plays a very important role in teradata. It is used in
data distribution. Very important for joins. SI provides
alternate path for data access.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is meant by a Virtual Disk?
Describe the between keyword in teradata?
What is multi insert?
What are the frequently used data types in teradata?
Define views in teradata with syntax.
what is referential constraints?how do you implement RI in teradata?
What are the multiload utility limitations?
What is the purpose of using case expression in teradata?
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
What type of indexing mechanism do we need to use for a typical data warehouse?
Why managing the data is important?
How to relege locks in fastload and multiload? example?
Teradata 
