Highlight the differences between Primary Key and Primary Index.
No Answer is Posted For this Question
Be the First to Post Answer
What are two examples of an OLTP environment?
In your project what type of issues and errors you facing in Teradata
Explain Teradata performance tuning and optimization?
Explain how spool space is used.
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
What is the purpose of joins in teradata and what are the available join types?
Differentiate primary key and partition key?
Explain the most common data types used in teradata?
How will you solve the problem that occurs during update?
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?
Hash collision?
If the table does not have duplicates then which utility you can suggest to load the data ?