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

Answer Posted / azhar

hi,

The difference might be in the granularity level....

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of incremental aggregation? Explain me in brief with an example?

572


What is latest version of power center / power mart?

544


Explain what are non-additive facts?

552


What is a general purpose scheduling tool?

545


How to allow a dynamic selection of a column for a measure in a chart,without using variable?

498






What is the difference between datawarehouse and bi?

507


What is the difference between data warehouse and operational systems?

586


What are data modeling and data mining?

643


What are necessary tasks to install reportnet software?

502


How to limit the max no of rows retrieved in the report?

542


How to handle multi value dimensions?

1772


What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

563


Explain the structure of cold fusion?

575


What are session timeout and application timeout?

520


Why is chameleon method used in data warehouse?

683