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 |
How to know the time taken for particular report execution?
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 me what is vldb?
What are the different types of scd's used in data warehousing?
What is the difference between a data warehouse and a data mart?
15 Answers Apex, ASD Lab, Bank Of America,
How can you communicate with web server (apache or iis) from coldfusion?
What is degenerate dimension table?
What are the steps of implementing data warehousing?
What is ods (operation data source)?
What is the function of etl when used in data warehousing?
Explain what are the methodologies of data warehousing?
Explain what are the different methods of loading dimension tables?