Interested to Buy Any Domain ? << Click Here >> for more details...
How do you design aggregate tables using teradata?
- 1 Answers
- 1589 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 are the differences between TerdataV2R5 and V12 Versions please??
Explain about Skew Factor?
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
What are the frequently used data types in teradata?
What are types of partition primary index (ppi) in teradata?
Explain the advantages of partitioned primary index in a query?
If a Node is busy what are the steps you can take to avoid ?
What are the joins in teradata?
How do you eliminate duplicates?
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,
What is dimensional modeling?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
Teradata 
