what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / sandeep
the following points are differ from fact table desiging
summary table :
1. use of intelligent key or non - intelligent key
2.use of abbrevatons decoded on the fly
3.use of embedded refernce keys
4.which columns to include that is vertical partitioning
strategy
5.horizontal partitioning strategy
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between constraind base load ordering and target load plan?
List down some of the real time data-warehousing tools?
Explain swot analysis?
What is Star Schema?
what are the all possible features supported modify stage?
How to know the time taken for particular report execution?
How do we design a universe?
What is the difference between er modeling and dimensional modeling?
Why should you put your data warehouse on a different system than your oltp system?
Explain what are non-additive facts in detail?
Explain the main difference between inmon and kimball philosophies of data warehousing?
What is analytical or analytic mean?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What are fundamental stages of data warehousing?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?