Answer Posted / reddy

Teradata viewpoint shows the session ID, user ID,runtime,
expected row count,spool space occupied, approximate
completion time of the query.
Viewpoint shows the details of active sessions only.

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

932

---

What are the available primary index types in teradata.

972

---

What is spool space?

1074

---

In Teradata, what is the significance of UPSERT command?

1129

---

What are the string manipulation operators and functions associated with teradata?

1024

---

How you will check the version of teradata?

1076

---

What is real time and near real time data warehousing?

1062

---

In general, how do you optimze any sql in teradata?

973

---

What is the basic syntax for teradata select statement?

982

---

What are the functions of a Parser?

1027

---

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

979

---

if collect stats but it show low confidence why?

1618

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1058

---

What are some commonly used bteq scripts?

942

---

Highlight all the modes that are present under Confidence Level.

915

---