Questions:
1. Software vendor uses the term Strategic Enterprise Management (SEM). Cognos uses the term Corporate Performance Management (CPM), and Hyperion uses the term Business Performance Management (BPM). Are they talking about the same basic thing, or are they different concepts? Justify your posts with facts and research.
2. What is are the differences and similarities between star schema, and snowflake schema? Can you find a diagram on the web of a snowflake schema
3. Why bother with a different type of schema for a data warehouse? Why not use the same, heavily normalized type of scheme used in operational databases?