what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 51166 Views
- Target, I also Faced
- E-Mail Answers
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 latest version of power center / power mart?
How to handle multi value dimensions?
What is the difference between ods and oltp?
What is the data type of the surrogate key?
What is surrogate key? Where we use it? Explain with examples.
What are the different types of fact tables used in data warehousing?
Explain the definition of normalized and denormalized view and what are the differences between them?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What are the different models used in cluster analysis?
what are the all possible features supported modify stage?
How we are using this function?
How to design file watch jobs?
What is drill-through?
Explain how are the dimension tables designed?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
