How do you design aggregate tables using teradata?
- 1 Answers
- 862 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 |
How do you load Multiple files to a table by using fastload scripts?
Explain the term 'foreign key' related to relational database management system?
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
which option is used to restart the fast load script?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance
Name the five phases that come under MultiLoad Utility.
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
how can i answer for question like teradat architecture in interveiw
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
Aborted in Phase 1 data Acquistion Incomplete in fastload?
Teradata 
