How do you design aggregate tables using teradata?
- 1 Answers
- 1199 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 |
List the logical and conditional operators that are used with teradata along with their meanings?
what is object level locking ? where do appear this type of locking ?
I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com
201 Answers Cognizant, Deloitte, IBM, Prometric, Syntel,
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
what is use of PI(primary index) AND SI(secondary index)
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Explain the term 'tables' related to relational database management system?
How many codd's rules are satisfied by teradata database?
What is the syntax for case when statement?
Explain teradata architecture?
Teradata 
