Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default join strategy in Teradata???
- 5 Answers
- 25385 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / dg
The Teradata Cost based optimizer will decide the join
strategy based on the optimum path. The common startegies
followed are from Merge, Hash & Nested Join
| Is This Answer Correct ? | 25 Yes | 3 No |
Post New Answer View All Answers
What are the scenarios in which full table scans occurs?
Explain the term 'columns' related to relational database management system?
What is real time and near real time data warehousing?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is meant by Teradata Gateway?
How to Extract data from multiple legacy systems?
What is the meaning of Caching in Teradata?
What are the enhanced features in teradata v2r5 and v2r6?
Differentiate primary key and partition key?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is a node in teradata? Explain
Highlight all the modes that are present under Confidence Level.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Which is faster fastload or multiload?
What is meant by a Channel Driver?
