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 teradata?

728

---

Explain the parallel data extension in teradata?

736

---

How can we check the version of Teradata that we are using currently?

690

---

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

683

---

What are tpump utility limitations?

722

---

---

What are the steps to create a data model?

696

---

What is stored procedure in teradata?

673

---

What is the difference between fastload and multiload? Which one is faster?

733

---

What is the use of fallback?

639

---

How to run a query in teradata?

675

---

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

738

---

What is the purpose of using case expression in teradata?

657

---

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

665

---

What is logical data model?

751

---

What is the basic syntax for teradata select statement?

669

---