What are aggregate tables? How do you design them using Teradata?
Posted On: Feb 22, 2018
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.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Teradata Interview Questions
Explain Teradata utilities. What is MultiLoad , Fast Load, Tpump ?
Teradata utilities offer a powerful solution for managing all your data load requirements from batch to real-time. FastLoad can sort the incoming rows directly into the target table. MultiLoad first...
Teradata Interview Questions
When do you use each of these? Why? Explain in detail.
It is used because Teradata utilities offer a powerful solution for managing all your data load requirements from batch to real-time....
Teradata Interview Questions
Explain Teradata Architecture in detail .
Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET, and Access Module Processors (AMPs)....