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
- 53527 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
Explain the importance of data warehouse?
What is the 4 + 1 view model as it relates to system modeling?
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.
How to create prompts in report net?
What is the data type of the surrogate key?
What is vdl (view definition language) explain?
What is the difference between star and snowflake schemas?
How do you define data block size?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is the difference between dependent data warehouse and independent data warehouse?
How to design file watch jobs?
What is called data cleaning?
What is perform recovery?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
