what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / 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 ? | 52 Yes | 3 No |
Post New Answer View All Answers
What is the main difference between inmon and kimball philosophies of data warehousing?
What is cost benefit analysis (cba)?
What are the steps involved in designing a fact table?
What is the purpose of cluster analysis in data warehousing?
How to add a number to a macro variable?
List down some of the real time data-warehousing tools?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Describe the differences between a data warehouse and data mart.
What is the difference between Datawarehouse and OLAP?
How can you communicate with web server (apache or iis) from coldfusion?
What is drill-through?
What is the limit to the number of sources and targets you can have in a mapping?
Explain the difference between dw and bi?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain why are oltp database designs not generally a good idea for a data warehouse?