Answer Posted / ram

Permanent Tables:
1. SET table - Strictly NO duplicate values [By-Default]
2. MULTI SET table - Allows Duplicate Values.

Temporary Tables:
1. Global Temporary Table - supports [Compression in table],
when session logged out, Table persists and its record gets
vanished.
2. Volatile Table - When session logged out, TABLE and its
records are not available further.
3 derived able
4 error table(t13)

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

4113

---

What are the various indexes in teradata?

582

---

What are the various indexes in teradata? How to use them? Why are they preferred?

605

---

If RDBMS is halted what will you do ?

1717

---

Can we collect statistics on multiple columns?

577

---

---

What is difference between user and database in teradata?

626

---

Explain teradata architecture?

645

---

What is node? How many nodes and amps used in your previous project?

687

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1907

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

642

---

Explain the term 'row' related to relational database management system?

545

---

Explain fastload in teradata?

617

---

List out some of the primary characteristics of teradata.

575

---

Explain teradata architecture in detail with a diagram.

634

---

Difference between stored procedure and macro?

697

---