Interested to Buy Any Domain ? << Click Here >> for more details...
Give some points about Teradata Viewpoint ?
- 3 Answers
- 13291 Views
- Teradata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tdguy
TD viewpoint is a framework where applications are
displayed. This web based framework can be used to manage
and monitor the teradata systems using a browser.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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.
| Is This Answer Correct ? | 5 Yes | 8 No |
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
how can we analyze the locks ?
What's the difference between timestamp (0) and timestamp (6)?
What are the uses of client software involved in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
If RDBMS is halted what will you do ?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Can we collect statistics on table level?
What do you mean by teradata sql assistant?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
What are the available join types in teradata?
What do you mean by caching in teradata?
Teradata 
