what is the difference between aggregate table and fact
table ? how do you load these two tables ?




Answers were Sorted based on User's Feedback



what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / harshad

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 ?    51 Yes 3 No

what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / tadikonda

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 ?    46 Yes 10 No

what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / chithra. k

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 ?    18 Yes 2 No




what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / santosh

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 ?    15 Yes 5 No

what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / surya

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 ?    11 Yes 2 No

what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / sandeep

the following points are differ from fact table desiging
summary table :

1. use of intelligent key or non - intelligent key
2.use of abbrevatons decoded on the fly
3.use of embedded refernce keys
4.which columns to include that is vertical partitioning
strategy
5.horizontal partitioning strategy

Is This Answer Correct ?    2 Yes 0 No

what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / azhar

hi,

The difference might be in the granularity level....

Is This Answer Correct ?    5 Yes 4 No

what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / nethaji

fact table has measures and aggregated data .Aggregate table
has only aggregate value (ie) precalculated value.

Is This Answer Correct ?    3 Yes 9 No

what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / ajit dada pawar

fact table is one which contains all the facts
.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 9 No

what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / plaban

The main difference is the type of involvement in Schema

Is This Answer Correct ?    1 Yes 12 No

Post New Answer



More Data Warehouse General Interview Questions

What is incremintal loading?

0 Answers  


Explain what are the advantages data mining over traditional approaches?

0 Answers  


What is Grain & Granularity in Data Warehouse.

2 Answers   TCS, TVS,


What is the differences between star and snowflake schemas?

0 Answers  


What is the difference between view filter and report filter?

0 Answers  






What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh

6 Answers   ACS,


What are non-additive facts in detail?

0 Answers  


Explain what is the difference between olap and datawarehosue?

0 Answers  


Explain what are the different methods of loading dimension tables?

0 Answers  


What is drilling across?

0 Answers  


What is VLDB?

0 Answers  


Where the data cube technology is used?

0 Answers  






Categories