Answer Posted / bharath

guys rowid concept is discontinued in teradata as far as my
knowledge goes, we can always use below sql ...

INSERT INTO nodupes_table ( all_columns )
SELECT all_columns
FROM dupes_table
QUALIFY ...

where the QUALIFY ... can be (depending on your version):
/* V2R5 syntax */
QUALIFY ROW_NUMBER() OVER (PARTITION BY all_columns
ORDER BY all_columns) = 1

/* or V2R4 and higher equivalent functionality */
GROUP BY all_columns
QUALIFY CSUM(1, all_columns ) = 1

/* or, alternative OLAP SUM V2R4 and higher syntax */
QUALIFY SUM(1) OVER (PARTITION BY all_columns ORDER BY
all_columns ROWS
UNBOUNDED PRECEDING ) = 1


I do think an insert-select into a set table would be a
cleaner process (don't know about runtime, though):
INSERT INTO nodupes_set_table ( all_columns )
SELECT all_columns
FROM dupes_table;


refer to teradata forum for more info

What is meant by a Clique?

1058

---

What are normalization, first normal form, second normal form and third normal form?

1048

---

What is the difference between teradata and oracle?

1019

---

What are the primary characteristics of the Teradata.

1137

---

What are some primary characteristics of teradata?

998

---

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 ?

2471

---

What are the different softwares used with their functions in teradata?

1012

---

What happens when a node suffers a downfall?

1120

---

What is a dimension table?

1054

---

What is a three-tier data warehouse?

1106

---

List out teradata data types?

1002

---

What are the functions of a Parser?

1098

---

Explain parsing engine in teradata?

1086

---

how many modules are there in telecome domain?how to explain the architecture?

2013

---

Write a program to show the parser component used in teradata?

969

---