Answer Posted / uli

ViewPoint is a separate Server, which collects usage/performance data and presents it via a collection of apps for a general overview, down to a single process.
QueryMonitor, one application in ViewPoint, shows System resource usage like CPU/Spool space/.. -usage, Blocks and blocking process, explain plan ...
QueryMonitor has Rewind capability, to show not only current processes, but is able to go back in time for whatever period the server is configured to hold the data.

Describe the set operators in teradata.

581

---

Explain PDE.

604

---

What are different table types used in teradata?

582

---

Describe the between keyword in teradata?

612

---

Why is the case expression used in teradata?

590

---

---

What are the different design perspectives used in teradata?

548

---

What are the commands to make a new table, change a table and remove a table in teradata?

610

---

What is bteq script in teradata?

631

---

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1279

---

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

369

---

What are some commonly used bteq scripts?

563

---

What are the scenarios in which full table scans occurs?

537

---

Give a justifiable reason why Multi-load supports NUSI instead of USI.

675

---

Explain the new features of teradata?

565

---

What is a dimension table?

608

---