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
- 53075 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 are data mart and dwh normalized or denormalized? Do both of them exist in
Explain the data type of the surrogate key?
How to pivot row data using informatica?
Explain what are the mapping paramaters and maping variables?
Explain the differences between normalizer and normalizer transformation?
can anybody mail me the FAQS for hyperion essbase amd planning
Explain what is metadata reporter?
How to load the time dimension?
List any five applications of data warehouse.
What are the steps to build the datawarehouse?
Explain what are the various file formats involved in reportnet?
What are the advantages of cold fusion?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain what are the different methods of loading dimension tables?
