How do you design aggregate tables using teradata?
- 1 Answers
- 1002 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 |
What is upsert statement in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Which Teradata concept allows more than one model generation?
What is the purpose of using case expression in teradata?
Difference between multiload and tpump?
How to select first n records in teradata?
what is object level locking ? where do appear this type of locking ?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
any one pls tell me what are the table names in banking project?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Teradata 
