How do you design aggregate tables using teradata?
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 the difference between primary index and secondary index?.
What is SQL Assistence?please eample
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
Highlight the advantages of PPI(Partition Primary Index).
Discuss the advantages of using partitioned primary index in a query?
How to run the Teradata jobs in unix environment ???
Fast Load Script is failed and error tables are available then how do you restart?
Highlight the points of differences between the database and user in Teradata.
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
Highlight a few of the important components of Teradata?
Why teradata is used?
what are the uses of fact table and dimension table in banking project?