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 do you mean by teradata sql assistant?

1112

---

Which is faster fastload or multiload?

1178

---

Write a program to show the parser component used in teradata?

1026

---

what are the uses of fact table and dimension table in banking project?

4600

---

What are the various indexes in teradata? Why are they preferred?

1053

---

Explain the types of join supports by teradata?

1041

---

Highlight the advantages of PPI(Partition Primary Index).

1125

---

Explain some differences between mpp and smp?

1157

---

What is bteq script in teradata?

1211

---

What is the use of stored procedures in teradata?

1046

---

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

1039

---

What do you mean by caching in teradata?

1103

---

Difference between stored procedure and macro?

1218

---

What is the opening step in basic teradata query script?

1091

---

What is the difference between teradata and basic rdbms?

1072

---