what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Why fact table is in a normal form?
What is defined as partial backup?
What is IQD file?
The same tier?
What is the capacity of power cube?
What is difference macros and prompts?
Explain vldb?
What are templates in which way it is help full?
What are the steps involved in designing a fact table?
Define Data Warehousing?
What does level of granularity of a fact table signify?
Explain what are the steps to build the data warehouse?