I am currently responsible for a large MOLAP environment with lots of users and I am now responsible for taking over a large relational data warehouse. Is there a set of standard questions I can ask that will help me determine when it's best to use a MOLAP strategy vs. aggregating in a relational materialized view?
Clay Rehm's Answer: During your one-on-one and group interviews, the standard set of questions would include:
After the interviews are complete, you should be able to compile your findings and have patterns developed to help determine a strategy.
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access