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


Please Help Members By Posting Answers For Below Questions

What is cfapplication tag?

547


What are non-additive facts in detail?

514


Explain is olap databases are called decision support system true/false?

530


Suppose we want to display zero when null values coming to report how can we do that?

501


What are various warehousing tools?

552






What is meant by metadata in context of a data warehouse?

471


Explain why fact table is in normal form?

518


What is the difference between er modeling and dimensional modeling?

577


Explain me what are data marts?

565


What are the possible data marts in retail sales?

516


What is fact less fact table? Where you have used it in your project?

485


What are the data types present in bo? What happens if we implement view in the designer n report?

524


What are the steps involved in creating dimensional modeling process?

543


What is vldb(very large databases)?

523


What are steps we have to follow in designing the userfriendly universe?

528