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
- 53975 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 are the different views that are considered when building an object-oriented software system?
What are Aggregate tables?
How to eliminate duplicate rows from flat file?
What are the various transformation available?
What is the very basic difference between data warehouse and operational databases?
List any five applications of data warehouse.
What is data stream and data adaopter. Is it same are different? Explain?
How can we run the graph?
What are the types of SCD?
What is the difference between power center & power mart?
Explain the difference between data ware house & data mart?
What is data analysis? Where it will be used?
What is the difference between view materialized view and view?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
How to create prompts in report net?
