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
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???
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?
What are the components provided on node?
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
in teradata level primary in table level allows duplicates why?
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.
Name the five phases that come under MultiLoad Utility.
What are the various indexes in teradata? How to use them? Why are they preferred?
what is DYNAMIC SQL in TD?
What is the default join strategy in Teradata???
how teradata fetches a row from primary index table?
Highlight the differences between Primary Key and Primary Index.