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
Explain what are components of report studio?
What is the difference between view materialized view and view?
What is mean by aggregate aware?
What is surrogate key? Where we use it explain with example?
Explain why are oltp database designs not generally a good idea for a data warehouse?
What is data warehouse architecture?
what is an use case?
Tell me what is full load & incremental or refresh load?
How to create context?
Who needs data warehousing?
Explain what are the advantages data mining over traditional approaches?
I know of using applysimple, but there are other ways too?
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain what is the advantages data mining over traditional approaches?
Explain the versions of reportnet?