What are aggregate fact tables ? why they are needed? give
an example
Answer Posted / omprakash
It is used to improve the performance of sql query
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain me what is vldb?
What is real-time datawarehousing?
Explain why should you put your data warehouse on a different system than your oltp system?
What is aggregate fact table?
What are the possible data marts in retail sales?
Explain can a dimension table contains numeric values?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are data validation strategies for data mart validation after loading process?
What is hybrid slowly changing dimension?
Explain what is the difference between powerplay transformer and power play reports?
What is a full backup?
Explain hybrid slowly changing dimension?
What is metadata in context of a datawarehouse?
Is there any rownum object from which we can do this?
Explain what are the modules in power mart?