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
- 53597 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / santosh
The difference that i know is that the aggregate tables
contain only the summaries of the data where as the fact
tables contain summaries and measures. i.e.,the grain of
the data present in fact table is more than the grain of
the data present in aggregate tables.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
Explain what is power center repository?
What is normalization, first normal form, second normal form, third normal form?
Do you view contain data?
Explain why fact table is in normal form?
Explain what is fact less fact table? Where you have used it in your project?
Explain what are the advantages of query studio compared to report studio?
Compare aggregates and data marts
Explain the versions of reportnet?
What needs to be done while starting the database?
What is scd1 , scd2 , scd3?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What is an er diagram?
Where the applications and where ware house management system is used?
Why denormalization is promoted in universe designing?
Explain can report net connect multiple datasource at a time in report creation time?
