what is the difference between aggregate table and fact
table ? how do you load these two tables ?

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


Please Help Members By Posting Answers For Below Questions

What is the function of etl when used in data warehousing?

516


Explain the data type of the surrogate key?

548


What is Star Schema?

622


Explain what are components of report studio?

544


What are the steps to build the datawarehouse?

563






How can we acheive correlated sub-query in designer?can anyone help me in this regard?

472


Explain what is cost benefit analysis (cba)?

519


What is defined as partial backup?

606


What is the difference between er modeling and dimensional modeling?

577


What are the different ways to represent the loading of dimension tables?

497


What is real-time datawarehousing?

578


What are the stages of datawarehousing?

526


Why facts table is useful in representing the data?

478


How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

542


What function should we use to display the value entered or selected by a user in response to a prompt?

489