Give some points about Teradata Viewpoint ?
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 |
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
which join mostly use in realtime?
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
Can any one plz provide the teradata interview questions?
Explain the meaning of Amp?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
What is the difference between teradata and oracle?
teradata support to automatically increase the character length or not?
Explain the term 'row' related to relational database management system?
What is the purpose of upsert command?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?