Answer Posted / tdguy

Identity Columns are system generated numbers for every row
as it is inserted in the table.These columns ensure row
uniqueness in a table.
create table emp
(empno integer
generated always as identity
max value 1000
)
primary index(empno);

What is meant by a dispatcher?

955

---

What are the available primary index types in teradata.

973

---

What is the purpose of joins in teradata?

1067

---

Can you fastexport a field, which is primary key by putting equality on that key?

1116

---

During the Display time, how is the sequence generated by Teradata?

968

---

What is meant by Teradata Gateway?

1003

---

Where is teradata rdbms used?

1036

---

What happens in a conflict? How do you handle that?

987

---

how do you manage the production space. what are the proactive methods you can take ?

1881

---

What is the purpose of using case expression in teradata?

955

---

What is basic teradata query language?

1032

---

How do you do backup and recovery in teradata?

960

---

How many types of joins are there in teradata?

914

---

Explain the term 'primary key' related to relational database management system?

979

---

What is a node in teradata?

935

---