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
- 53240 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is data mart in data warehouse?
What are various warehousing tools?
Explain difference between data ware house & data mart?
What are the differences between star and snowflake schema?
Explain what is analytical or analytic mean?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
How to create different types of templates?
Explain the difference between view and materialized view?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What are Aggregate tables?
What is Discover and Execute in XMLA?
What is fact less fact table? Where you have used it in your project?
What are the different types of schemas used in data warehousing?
Explain the main differences between star and snowflake schema?
Explain the difference between data ware house & data mart?
