what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 51164 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
Explain me what is vldb?
What are the different models used in cluster analysis?
What are the stages that are required in data warehousing?
What is Discover and Execute in XMLA?
What is the difference between view materialized view and view?
What is a data profile?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Is there any default username & pwd for bo designer & supervisor?
What is execution plan?
What are session timeout and application timeout?
What is data warehosuing hierarchy?
Ist the schema that a data warehouse system can implements.
Describe the differences between a data warehouse and data mart.
Explain what is the difference between datawarehouse and bi?
Explain dimensional modelling?
