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 the main difference between schema in rdbms and schemas in datawarehouse?
What is perform recovery?
What is the extension of file to save template?
What are diagrams?
Difference between e-r modeling and dimentional modeling?
Explain normalization?
How to limit the max no of rows retrieved in the report?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Explain a relation schema and a relation?
Define Data Warehousing?
Explain the difference between view and materialized view?
Store (and count) non-fact records?
What are the different problems that ?Data mining? can solve?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Explain difference between e-r modeling and dimentional modeling?