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 is partitioning? What are the types of partitioning?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
What is the function of surrogate key in data warehousing?
Explain which are the olap tools available that are supported by oracle?
I know of using applysimple, but there are other ways too?
What is a fact, dimension, measure?
What are the advantages of cold fusion?
What is meant by metadata in context of a data warehouse and how it is important?
Explain what is the difference between olap and datawarehosue?
Explain what are the different types of data warehousing?
How can we schedule the graph in unix?
Explain what are necessary tasks to install reportnet software?
Explain what are non-additive facts in detail?
How can we load the time dimension?
Do you view contain data?