How teradata makes sure that there are no duplicate rows being inserted when its a set table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Teradata Interview Questions

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

0 Answers   IBM,


What are the components provided on node?

0 Answers  


Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load

4 Answers  


in teradata level primary in table level allows duplicates why?

1 Answers   TCS,






Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  


Name the five phases that come under MultiLoad Utility.

0 Answers  


What are the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  


what is DYNAMIC SQL in TD?

1 Answers   IBM,


What is the default join strategy in Teradata???

5 Answers   IBM,


how teradata fetches a row from primary index table?

1 Answers  


Highlight the differences between Primary Key and Primary Index.

0 Answers  


Categories