what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / jayalakshmi
fact table is one which contains all the facts
(measures).aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.
Is This Answer Correct ? | 14 Yes | 50 No |
Post New Answer View All Answers
What are steps we have to follow in designing the userfriendly universe?
What is an er diagram?
what type of raid setup would you put your tx logs?
How to limit the max no of rows retrieved in the report?
How to define a cube??
Fact table is in normalized or de-normalized form?
What are components of report studio?
I know of using applysimple, but there are other ways too?
What is Operational Data Store?
What are target types on the server?
In document how to create metrics?
Explain what is cost benefit analysis (cba)?
What are the different types of data warehouses?
Explain differences between star and snowflake schemas?
What is the difference between agglomerative and divisive hierarchical clustering?