what happen if a query fail in dispatcher?
Answer / mahi
if there are any errors the request doesn't come to
dispatcher.
| Is This Answer Correct ? | 2 Yes | 3 No |
Difference between Qualify and group
What are the enhanced features in teradata v2r5 and v2r6?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
What are the various indexes in teradata? Why are they preferred?
What is real time and near real time data warehousing?
What is the command in bteq to check for session settings ?
How to load specific no.of records using bteq, or fastload,or multiload
Highlight a few of the advantages that ETL tools have over Teradata.
What is meant by a Least Cost Plan?