Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 53631 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / tadikonda
Diff b/w two tables is performance.
Fact tables contains million of records and retriving the
records from fact table takes time.where as aggregate table
contains limited data from all the required tables,and we
retrive the data it takes less time.
| Is This Answer Correct ? | 46 Yes | 10 No |
Post New Answer View All Answers
Can we have multiple application.cfm file in an application?
Explain what is the difference between stop and abort?
Explain ddl (data definition language)?
Why null values are mapped as 0 in fact tables?
Explain dimensional modelling?
How to create different types of templates?
What is cost benefit analysis (cba)?
What needs to be done when the database is shutdown?
Explain the structure of cold fusion?
How can you implement many relations in star schema model?
What is the difference between olap and oltp?
What is factless fact tables?
Compare cold fusion with other programming languages?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is the function of surrogate key in data warehousing?
