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
- 53062 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / surya
Aggregate tables also known as summary tables, are fact
tables which contain data that has been summarized up to
different level(Month level, year level) of detail
aggregation.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Explain how to generate iqd file from framework manager?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is the difference between view filter and report filter?
what are the different views that are considered when building an object-oriented software system?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Why denormalization is promoted in universe designing?
How to generate iqd file from framework manager?
Do you view contain data?
What are data validation strategies for data mart validation after loading process?
What is the function of etl when used in data warehousing?
What is Active Datawarehousing?
Explain what are slowly changing dimensions?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Why should you put your data warehouse on a different system than your oltp system?
