what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / ajit dada pawar
fact table is one which contains all the facts
.aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.
Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
Where the applications and where
Which columns go to the fact table and which columns go the dimension table?
What are the different models used in cluster analysis?
Compare cold fusion with other programming languages?
How to test report in reportnet?
Explain why fact table is in normal form?
What is data stream and data adaopter?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is freehand sql?
What is vldb(very large databases)?
What is the difference between star and snowflake schemas?
how much memory space occupied real time project (roughly)?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Where the applications and where ware house management system is used?