Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

How do you design aggregate tables using teradata?

Question Posted / akhelesh kumar


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

Post New Answer

More Teradata Interview Questions

Explain and compare pros and cons of snow flake schemas?

0 Answers  

what is the difference between filter and router transmissions

2 Answers  

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80

12 Answers   CTS,

How do you load Multiple files to a table by using fastload scripts?

1 Answers   Satyam,

How will you solve the problem that occurs during update?

0 Answers  

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,

How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  

1.what is activity count? 2.what is skew factor? how it's working explain brefily

5 Answers   Satyam,

Why Multiload does not supports USI and supports NUSI?

4 Answers  

How would you load a very large file in teradata in general? What utility would you use for it? Why?

0 Answers  

What are the various indexes in teradata? Why are they preferred?

0 Answers  

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

0 Answers   Infosys, Wells Fargo,

For more Teradata Interview Questions Click Here
Categories