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);

How you will check the version of teradata?

1168

---

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1240

---

Can we collect statistics on table level?

1036

---

What do you mean by teradata sql assistant?

1062

---

Differentiate database data and data warehouse data?

1116

---

Where is teradata rdbms used?

1097

---

What happens when a node suffers a downfall?

1131

---

What are the 5 phases in a multiload utility?

1036

---

What is partitioned primary index (ppi)?

1048

---

How to Extract data from multiple legacy systems?

1122

---

What is the difference between global temporary tables and volatile temporary tables?

1182

---

Explain and compare pros and cons of snow flake schemas?

1035

---

What is a dimension table?

1063

---

What are differences between teradata and ansi session modes in teradata?

1175

---

What is logical data model?

1205

---