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



what is the difference between aggregate table and fact table ? how do you load these two tables ?..

Answer / selvaraj v

Sorry guys i am not sure

Is This Answer Correct ?    5 Yes 18 No

what is the difference between aggregate table and fact table ? how do you load these two tables ?..

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

Post New Answer

More Data Warehouse General Interview Questions

How to know the time taken for particular report execution?

0 Answers  


Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

0 Answers  


Explain me what is vldb?

0 Answers  


What are the different types of scd's used in data warehousing?

0 Answers  


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?

0 Answers  


What is degenerate dimension table?

0 Answers  


What are the steps of implementing data warehousing?

0 Answers  


What is ods (operation data source)?

0 Answers  


What is the function of etl when used in data warehousing?

0 Answers  


Explain what are the methodologies of data warehousing?

0 Answers  


Explain what are the different methods of loading dimension tables?

0 Answers  


Categories