What is Join Index in TD and How it works?
Answer Posted / yuvaevergreen
Join index stores the joined rows to two or more tables in
the permanent space. Not beneficiary always. Space
consumptions may be a problem. Can be used whenever large
tables are consistently and frequently joined and space may
not be a problem.
Is This Answer Correct ? | 10 Yes | 2 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?
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
Explain the term 'row' related to relational database management system?
How can you track login parameters of users in teradata?
What is stored procedure in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is the purpose of indexes?
what are the uses of fact table and dimension table in banking project?
What are the available primary index types?
What are types of partition primary index (ppi) in teradata?
What are the advantages of teradata?
Explain the teradata primary index mechanics in detail with a diagram.
Name the five phases that come under MultiLoad Utility.
What is difference between user and database in teradata?
Highlight all the modes that are present under Confidence Level.