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 junk dimension and degenerated dimension?
What is the difference between drill through and masterdetail reports?
What is perform recovery?
What is meant by metadata in context of a data warehouse?
Explain what are slowly changing dimensions?
What are fundamental stages of data warehousing?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Why is dimensional normalization not required?
What are non-additive facts in detail?
Explain about core dimension,
if you use oracle sql*loader , how do you transform data with it during loading?
Explain the hierarchies level data warehousing.
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
How can we load the time dimension?
What are the possible data marts in retail sales?