Interested to Buy Any Domain ? << Click Here >> for more details...
Pls any body reply for this question.
Which circumstance does the optimizing choose a product join?
Thanks for advance
- 6 Answers
- 14231 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Small correction to my answer mentioned above. Join
mentioned in the statement is actually cartesian product
join. SELECT * FROM A,B will result in cartesian product and
not product join. Product joins would be chosen for join
conditions containing inequality.
| Is This Answer Correct ? | 1 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 the frequently used data types 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 smp and mpp platforms?
Explain teradata architecture?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Why managing the data is important?
Explain teradata vs. Redshift?
What is partitioned primary index (ppi)?
What is the difference between global temporary tables and volatile temporary tables?
how many modules are there in telecome domain?how to explain the architecture?
What is oltp?
What is the purpose of joins in teradata?
Highlight the need for Performance Tuning.
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
