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 |
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
what are the default access rights in the teradata?
What is the use of fallback?
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
How do you do backup and recovery in teradata?
where we can use the delimiter in mload? pls let me know
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
What are tpump utility limitations?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
which join mostly use in realtime?
What is the difference between fastload and multiload? Which one is faster?