Answer Posted / yuvaevergreen

yes...the above option can be used if access has been
provided to create set tables.If not, partition by clause
can be used.
1. create table2 as table1 with no data;
2. insert into table2
sel column1,column2,,,columnn from table1
group by 1,2
qualify row_number() over (partition by
column1,column2,,,columnn order by
column1,column2,,,columnn desc) =1
where table1 is with duplicates and table2 would be target
table.

Explain how spool space is used.

1017

---

What is the purpose of joins in teradata and what are the available join types?

1000

---

Is multi insert ansi standard?

2142

---

List the logical and conditional operators that are used with teradata along with their meanings?

938

---

How do you see a ddl for an existing table?

961

---

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4319

---

Explain teradata architecture in detail with a diagram.

1044

---

What is a clique?

1011

---

What are the joins in teradata and how many types of joins are there in teradata?

957

---

How do you define Teradata?

981

---

What are default access rights in teradata? What explicit right can be given to a user?

1055

---

What do you mean by fastexport in teradata?

939

---

What is the use of teradata system software?

983

---

Highlight a few of the advantages that ETL tools have over Teradata.

1030

---

Define views in teradata with syntax.

1021

---