How teradata makes sure that there are no duplicate rows being inserted when its a set table?
in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
If RDBMS is halted what will you do ?
Discuss the advantages of using partitioned primary index in a query?
List the logical and conditional operators that are used with teradata along with their meanings?
how teradata fetches a row from primary index table?
What is the difference between SI and JI?
What exactly do you know about catching in teradata?
Difference between inner join and outer join?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
What do you mean by caching in teradata?
What is collect statistics?
Explain the meaning of Amp?