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
- 53176 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
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
what type of raid setup would you put your tx logs?
Explain the different types of data warehousing?
What are the types of SCD?
What do you mean by static and local variable?
What is data type of the surrogate key?
What are steps we have to follow in designing the userfriendly universe?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How to design file watch jobs?
Explain what are the mapping paramaters and maping variables?
What are the fundamental elements of the data warehouse?
What are snapshots? What are materialized views & where do we use them?
Difference between e-r modeling and dimentional modeling?
What is called data cleaning?
What is operational data store (ods)?
