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 are the available primary index types?

1208

---

if collect stats but it show low confidence why?

1679

---

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1034

---

What are types of partition primary index (ppi) in teradata?

1045

---

What is meant by a node?

1039

---

What are some commonly used bteq scripts?

1005

---

What happens when a node suffers a downfall?

1120

---

Why are oltp database designs not generally a good idea for a data warehouse?

1052

---

What are the uses of client software involved in teradata?

981

---

What do you mean by caching in teradata?

1054

---

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2109

---

What are the available primary index types in teradata.

1028

---

What does sleep function does in fast load?

1129

---

Explain Teradata performance tuning and optimization?

1156

---

What are the different softwares used with their functions in teradata?

1011

---