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
- 53547 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
What is the main difference between schema in rdbms and schemas in datawarehouse?
Give some difference between oltp and olap.
Explain what are the basic needs to join two sources in a source qualifier?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
Explain how to get the first 100 rows from the flat file into the target?
What is the difference between agglomerative and divisive hierarchical clustering?
What is the difference between er modeling and dimensional modeling?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Explain the differences between normalizer and normalizer transformation?
Difference between PowerPlay transformer and power play reports?
Explain what is power center repository?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is aggregate fact table?
What is data mart in data warehouse?
What is scd1 , scd2 , scd3?
