Answer Posted / n

Sel HASHAMP(HASHBUCKET(HASHROW(PRIMARY_INDEX_COLUMNS)))
AS AMP_NO,
COUNT(*)
From DATABASENAME.TABLE_NAME
GROUP BY 1;

What is the purpose of using case expression in teradata?

574

---

How would you load a very large file in teradata in general? What utility would you use for it? Why?

599

---

What's the difference between timestamp (0) and timestamp (6)?

637

---

How many sessions of MAX is PE capable of handling at a particular time?

595

---

List the logical and conditional operators that are used with teradata along with their meanings?

554

---

---

Explain how spool space is used.

615

---

What are the steps involved after the disk manager passes the request?

580

---

What do you mean by parsing?

633

---

Highlight the advantages of PPI(Partition Primary Index).

562

---

What is the difference between union and union all in teradata?

621

---

What is bteq utility in teradata?

573

---

Explain the most common data types used in teradata?

589

---

Describe the between keyword in teradata?

612

---

Highlight a few of the advantages that ETL tools have over Teradata.

611

---

What is a three-tier data warehouse?

630

---