Answer Posted / yuvaevergreen

If atleast one column is distinct, we can delete using
delete statement.
EMPLOYEE TABLE:
EMPNO EMPNAME DEPT
1 YUVA SCI
2 YUVA SCI

DELETE FROM EMPLOYEE WHERE
(EMPNO, EMPNAME,DEPT)
NOT IN
(SELECT EMPNO, EMPNAME,DEPT FROM EMPLOYEE
QUALIFY ROW_NUMBER() OVER
(PARTITION BY EMPNO
ORDER BY EMPNO,EMPNAME,DEPT ASC ) = 1 );

If all the columns are same, then create and drop would be used.

EMPNO EMPNAME DEPT
1 YUVA SCI
1 YUVA SCI

CREATE EMP_NEW AS EMP WITH NO DATA;
INSERT INTO EMP_NEW
SELECT EMPNO, EMPNAME,DEPT FROM EMPLOYEE
QUALIFY ROW_NUMBER() OVER
(PARTITION BY EMPNO, EMPNAME,DEPT
ORDER BY EMPNO,EMPNAME,DEPT ASC ) = 1;
DROP TABLE EMP;
RENAME EMP_NEW TO EMP;

What are types of partition primary index (ppi) in teradata?

1001

---

What are different table types used in teradata?

981

---

Explain teradata architecture?

1033

---

What tools would you use for that?

1029

---

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 ?

2421

---

What do you mean by caching in teradata?

996

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

940

---

Explain some differences between mpp and smp?

1037

---

Describe primary index in teradata?

959

---

What is the use of fallback?

941

---

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

1002

---

Can we collect statistics on multiple columns?

988

---

What are the functions of a teradata dba?

1024

---

What are the functions performed by bynet?

982

---

Describe primary index in teradata. And what are the available primary index types?

941

---