what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 51162 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / nethaji
fact table has measures and aggregated data .Aggregate table
has only aggregate value (ie) precalculated value.
| Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What are the types of dimensional modeling?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain why fact table is in normal form?
What is the difference between er modeling and dimensional modeling?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain what is the difference between stop and abort?
I have two universes created by two difference database can we join them in designer & report level? How
What is static and local variable?
What is a source qualifier?
What according to you might be the future of data warehousing?
Explain differences between star and snowflake schemas?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
how much memory space occupied real time project (roughly)?
Explain what is partitioning? What are the types of partitioning?
