ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
what is the difference between aggregate table and fact
table ? how do you load these two tables ?
 Question Submitted By :: Itsranjan
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the difference between aggregate table and fact table ? how do you load these two tables ?
Answer
# 1
fact table is one which contains all the facts
(measures).aggregate table is one which is created after 
the cube is processed.this aggregate table contains human 
unreadable text.
 
Is This Answer Correct ?    1 Yes 2 No
Jayalakshmi
 
  Re: what is the difference between aggregate table and fact table ? how do you load these two tables ?
Answer
# 2
Diff b/w two tables is performance.

Fact tables contains million of records and retriving the
records from fact table takes time.where as aggregate table
contains limited data from all the required tables,and we
retrive the data it takes less time.
 
Is This Answer Correct ?    1 Yes 0 No
Tadikonda
 
 
 
  Re: what is the difference between aggregate table and fact table ? how do you load these two tables ?
Answer
# 3
Sorry guys i am not sure
 
Is This Answer Correct ?    0 Yes 1 No
Selvaraj V
 
  Re: what is the difference between aggregate table and fact table ? how do you load these two tables ?
Answer
# 4
The difference that i know is that the aggregate tables 
contain only the summaries of the data where as the fact 
tables contain summaries and measures. i.e.,the grain of 
the data present in fact table is more than the grain of 
the data present in aggregate tables.
 
Is This Answer Correct ?    1 Yes 0 No
Santosh
 
  Re: what is the difference between aggregate table and fact table ? how do you load these two tables ?
Answer
# 5
A fact table typically has two types of columns: those that 
contain numeric facts (often called measurements), and 
those that are foreign keys to dimension tables. A fact 
table contains either detail-level facts or facts that have 
been aggregated. Fact tables that contain aggregated facts 
are often called summary tables or aggregated fact. A fact 
table usually contains facts with the same level of 
aggregation. Though most facts are additive, they can also 
be semi-additive or non-additive. Additive facts can be 
aggregated by simple arithmetical addition. A common 
example of this is sales. Non-additive facts cannot be 
added at all. An example of this is averages. Semi-additive 
facts can be aggregated along some of the dimensions and 
not along others. An example of this is inventory levels, 
where you cannot tell what a level means simply by looking 
at it.
 
Is This Answer Correct ?    1 Yes 1 No
Harshad
 
  Re: what is the difference between aggregate table and fact table ? how do you load these two tables ?
Answer
# 6
hi,

   The difference might be in the granularity level....
 
Is This Answer Correct ?    0 Yes 0 No
Azhar
 
  Re: what is the difference between aggregate table and fact table ? how do you load these two tables ?
Answer
# 7
fact table has measures and aggregated data .Aggregate table
has only aggregate value (ie) precalculated value.
 
Is This Answer Correct ?    0 Yes 0 No
Nethaji
 
  Re: what is the difference between aggregate table and fact table ? how do you load these two tables ?
Answer
# 8
Aggregate tables also known as summary tables, are fact 
tables which contain data that has been summarized up to 
different level(Month level, year level) of detail 
aggregation.
 
Is This Answer Correct ?    0 Yes 1 No
Surya
 
  Re: what is the difference between aggregate table and fact table ? how do you load these two tables ?
Answer
# 9
The main difference is the type of involvement in Schema
 
Is This Answer Correct ?    0 Yes 0 No
Plaban
 
  Re: what is the difference between aggregate table and fact table ? how do you load these two tables ?
Answer
# 10
Fact tables generally contains measures and the composite 
key, which is generally a combination of foreign keys from 
the respective dimension tables.

Aggregate tables are summary tables which contains the 
summary information say for eg:total sales revenue (for a 
quarter).

So the difference is in the granularity.Fact tables store 
date in more detail level, but in aggregate tables the 
granularity is high.
 
Is This Answer Correct ?    0 Yes 0 No
Chithra. K
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
Can you explain how analysis service works?  1
What is a Data Cube?  1
What is an OLAP (On-line Analytical processing) system?  1
What is BCP?  1
Tell me one example for multi valued dimension or bridge table? TCS1
What is ?Data Warehousing??  2
What is MDX? TCS1
What is staging area?  6
What are CUBES?  2
What Oracle features can be used to optimize my Warehouse system?  1
What is confirmed dimension?  3
How can we import and export using BCP utility?  1
What Oracle tools can be used to design and build a W/H?  1
Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay. iFlex1
Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K Accenture2
What are cursors?  4
Explain about Control M JObs detaily?How to execute this. Scope-International2
What are Data Marts?  2
three ways sql*loader could load data, what are those three types?  1
3.What is fact less fact ? HCL2
 
For more Data Warehouse General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com