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
What is the function of etl when used in data warehousing?
Explain the data type of the surrogate key?
What is Star Schema?
Explain what are components of report studio?
What are the steps to build the datawarehouse?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain what is cost benefit analysis (cba)?
What is defined as partial backup?
What is the difference between er modeling and dimensional modeling?
What are the different ways to represent the loading of dimension tables?
What is real-time datawarehousing?
What are the stages of datawarehousing?
Why facts table is useful in representing the data?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What function should we use to display the value entered or selected by a user in response to a prompt?