Interested to Buy Any Domain ? << Click Here >> for more details...
How do you design aggregate tables using teradata?
- 1 Answers
- 1715 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 is spool space? Why do you get spool space errors? How do trouble-shoot them?
what is object level locking ? where do appear this type of locking ?
How many tables can you join in v2r5?
write lock is compatiable with which type of lock?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
Explain PDE.
Explain fastload in teradata?
What is primary index and secondary index?
What are the different methods ot loading a dimension table? A fact table etc?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain vproc in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Teradata 
