Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 53546 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
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Difference between cold fusion mx 6 and cold fusion mx 7?
Describe a data warehouse.
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Explain dimension table ?
What are data validation strategies for data mart validation after loading process?
Why null values are mapped as 0 in fact tables?
Where do we use semi and non additive facts?
Explain what are the methodologies of data warehousing?
Explain difference between e-r modeling and dimentional modeling?
Explain the versions of reportnet?
Explain ddl (data definition language)?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What is a linked cube?
What is the difference between aggregate table and materialized view?
