what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 51165 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
How to generate the cubes in framework manager?
What are snapshots? What are materialized views & where do we use them?
What is the use of incremental aggregation? Explain me in brief with an example?
Explain what is the difference between olap and datawarehosue?
What is factless fact tables?
How many project sources we can create in metadata?
What are the advantages and disadvantages of reporting directly against the database?
What is partitioning? What are the types of partitioning?
How can you set the client management?
what is an use case?
What is loop in data warehousing?
What are cluster analysis in data warehousing?
What is a cube in data warehousing concept?
Explain the different types of data warehousing?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
