Answer Posted / mallikharjunarao rayidi

Same as the 'TARGET TABLE'

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

541

---

How can you track login parameters of users in teradata?

638

---

How to view every column and the columns contained in indexes in teradata?

591

---

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

592

---

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

554

---

---

Highlight the differences between Primary Key and Primary Index.

625

---

How do you create tables? Exact syntax, and create profiles, users in teradata?

563

---

What is a clique?

587

---

How will you solve the problem that occurs during update?

589

---

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

603

---

How do you define Teradata?

610

---

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1508

---

What tools would you use for that?

574

---

Difference between stored procedure and macro?

692

---

Explain Teradata performance tuning and optimization?

703

---