Answer Posted / harsha

Error code is the code for the error for ex 3807 is the error code for the error "object does not exist"
To know the error codes type
select * from dbc.errormsgs
in the Queryman
Error level is the severity set for the corresponding error code
if error level is
0- Success
4- Warning
8- User Error
12- Fatal error
16- Typical Error

What is meant by a node?

842

---

Highlight the points of differences between the database and user in Teradata.

854

---

Difference between stored procedure and macro?

955

---

What is database exceptions in teradata?

757

---

What are different table types used in teradata?

832

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

780

---

Highlight the differences between Primary Key and Primary Index.

851

---

What is a clique?

820

---

What are some primary characteristics of teradata?

785

---

Explain teradata utilities. What is multiload, fast load, tpump?

813

---

What are the newly developed features of Teradata?

822

---

Can we collect statistics on table level?

834

---

Highlight a few of the important components of Teradata?

825

---

What are the different table types that are supported by teradata?

791

---

What is a node in teradata? Explain

813

---