what is the difference between aggregate table and fact
table ? how do you load these two tables ?
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 about dirty dimension?
What a static and local variable?
What are the various methods of getting incremental records or delta records from the source systems?
Explain a relation schema and a relation?
What is data analysis?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is batch processing?
Explain what is cost benefit analysis (cba)?
Explain difference between snow flake and star schema.
Explain how to generate iqd file from framework manager?
What is hybrid slowly changing dimension?
Compare cold fusion with other programming languages?
What is the 4 + 1 view model as it relates to system modeling?
Describe a data warehouse.
What are the stages of datawarehousing?