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 DYNAMIC SQL in TD?
What is the use of virtual processor connectivity in teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Explain and compare pros and cons of start schemas?
If a Node is busy what are the steps you can take to avoid ?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
Highlight the limitations of TPUMP Utility.
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is difference between user and database in teradata?
Did you write stored procedures in teradata?
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE