How teradata makes sure that there are no duplicate rows being inserted when its a set table?
- 1 Answers
- 1073 Views
- I also Faced
- E-Mail Answers
Answer Posted / Vikas Dubey
In Teradata's Set tables, duplicate rows are prevented using the Deduplication feature. This is done by storing only one copy of each unique row and maintaining pointers to the original row. When retrieving data, Teradata returns only the original row, not the pointers.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is node? How many nodes and amps used in your previous project?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
