How do you design aggregate tables using teradata?
- 1 Answers
- 1231 Views
- I also Faced
- E-Mail Answers
Answer / farheen
An aggregate table is those tables which contain the summary of the existing warehouse. It is used to save the time as retrieving data from a million of records in the actual table will take too much time. So, aggregate the tables to a certain level of dimensions and use them.
Teradata supports some aggregate functions which are:
COUNT: It is used to count the rows.
SUM: used to calculate the sum of specified columns.
MIN: To find the minimum value from specified columns.
MAX: to find the maximum value from specified columns
AVG: to calculate the average of specified columns.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
What are the different table types supported by teradata?
1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
6 Answers Bank Of America, Wipro,
Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me
What is the use of having index's on table?
what is the difference between primary index and secondary index?.
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
what is referential constraints?how do you implement RI in teradata?
What are the functions of a Parser?
Explain the term 'row' related to relational database management system?
In Teradata, what is the significance of UPSERT command?
What type of indexing mechanism do we need to use for a typical data warehouse?
Teradata 
