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

Where is teradata rdbms used?

666

---

Describe the between keyword in teradata?

610

---

What are the updated features of teradata?

576

---

Difference between star and snowflake schemas?

601

---

How do you define Teradata?

603

---

---

Highlight the need for Performance Tuning.

578

---

What are the scenarios in which full table scans occurs?

532

---

How can bottlenecks be identified?

571

---

What does Amp contain and what are all the operations that it performs?

583

---

What is the primary index in teradata?

584

---

What are the components provided on node?

568

---

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

566

---

Can we collect statistics on multiple columns?

561

---

What is teradata?

644

---

How would you load a very large file in teradata in general?

557

---