Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?

3 Answers  

teradata support to automatically increase the character length or not?

1 Answers  

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

0 Answers   IBM,

What are the functions involved in shared information architecture?

0 Answers  

Explain the most common data types used in teradata?

0 Answers  

Explain the advantages of partitioned primary index in a query?

0 Answers  

In Teradata, what is the significance of UPSERT command?

0 Answers  

Explain the term 'columns' related to relational database management system?

0 Answers  

how do you manage the production space. what are the proactive methods you can take ?

0 Answers  

Where is teradata rdbms used?

0 Answers  

Give some points about Teradata Viewpoint ?

3 Answers   Teradata,

While creating table my dba has fallback or no fallback in his ddl. What is that?

0 Answers  

For more Teradata Interview Questions Click Here
Categories