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
What is latest version of power center / power mart?
How to eliminate duplicate rows from flat file?
Explain why should you put your data warehouse on a different system than your oltp system?
How can we schedule the graph in unix?
What is the difference between metadata and data dictionary?
What is the difference between mapping parameter & mapping variable in data warehousing?
Where we use surrogate key explain with example?
What are the different models used in cluster analysis?
Explain what is type 2 version dimension?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is a staging area? Do we need it? What is the purpose of a staging area?
What is dimension modeling?
What should I have in mind when building olap solution from scratch?
What is difference between model & package?