Interested to Buy Any Domain ? << Click Here >> for more details...
How do you design aggregate tables using teradata?
- 1 Answers
- 1712 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 |
1.what is activity count? 2.what is skew factor? how it's working explain brefily
What is the difference between teradata and basic rdbms?
Explain the term 'row' related to relational database management system?
What is meant by a node?
On which column will you take primary index???
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
Explain the meaning of Amp?
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
What is a node in teradata? Explain
Define views in teradata with general syntax.
How do you verify a complicated sql?
what is referential constraints?how do you implement RI in teradata?
Teradata 
