What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
No Answer is Posted For this Question
Be the First to Post Answer
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How does indexing improve query performance?
What are the various indexes in teradata? How to use them? Why are they preferred?
What are the updated features of teradata?
What do you mean by teradata intellicloud?
What is the difference between fastload and multiload?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
If the table does not have duplicates then which utility you can suggest to load the data ?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
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?
How is the teradata different from oracle?
Explain the meaning of Amp?