what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 49537 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
Why is chameleon method used in data warehouse?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
how much memory space occupied real time project (roughly)?
What are the steps to build the datawarehouse?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
Explain swot analysis?
How can you set the client management?
What is the data type of the surrogate key?
Compare and contrast aggregates & indexes
Explain the difference between dw and bi?
What are the steps involved in designing a fact table?
Explain vldb?
What are the methodologies of data warehousing?
Can you pass sql queries in filter transformation?
How much data hold in one universe.
