what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / surya
Aggregate tables also known as summary tables, are fact
tables which contain data that has been summarized up to
different level(Month level, year level) of detail
aggregation.
Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What is cfapplication tag?
What are non-additive facts in detail?
Explain is olap databases are called decision support system true/false?
Suppose we want to display zero when null values coming to report how can we do that?
What are various warehousing tools?
What is meant by metadata in context of a data warehouse?
Explain why fact table is in normal form?
What is the difference between er modeling and dimensional modeling?
Explain me what are data marts?
What are the possible data marts in retail sales?
What is fact less fact table? Where you have used it in your project?
What are the data types present in bo? What happens if we implement view in the designer n report?
What are the steps involved in creating dimensional modeling process?
What is vldb(very large databases)?
What are steps we have to follow in designing the userfriendly universe?