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

Why fact table is in a normal form?

0 Answers  


What is defined as partial backup?

0 Answers  


What is IQD file?

1 Answers  


The same tier?

0 Answers  


What is the capacity of power cube?

2 Answers  






What is difference macros and prompts?

0 Answers  


Explain vldb?

0 Answers  


What are templates in which way it is help full?

0 Answers  


What are the steps involved in designing a fact table?

0 Answers  


Define Data Warehousing?

0 Answers   Wipro,


What does level of granularity of a fact table signify?

0 Answers  


Explain what are the steps to build the data warehouse?

0 Answers  


Categories