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
What is data analysis?
What is the metadata extension?
What is a relationship?
What is metadata in context of a datawarehouse?
What is hybrid slowly changing dimension?
What is the main difference between inmon and kimball philosophies of data warehousing?
What is load manager?
In microstrategy, how can we direct the sql generated to use a specifc table?
How many types of facts and what are they?
What is the differences between star and snowflake schemas?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what are the various file formats involved in reportnet?
What is freehand sql?
What is called dimensional modelling?
What is the working process for application.cfm?