Differentiate primary key and partition key?
No Answer is Posted For this Question
Be the First to Post Answer
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 is the function of parser component in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Name the five phases that come under MultiLoad Utility.
what is the structure of UV table in MLOAD?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is the process to restart the multiload if it fails?
What is a three-tier data warehouse?
Can you connect multiload from ab initio?
List out all forms of LOCKS that are available in Teradata.
Describe the set operators in teradata.
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?