You should have a star schema or a snowflake (denormalized marts which are denormalized schemas) in addition to your normalized schema per Ralph Kimball's methodology. Bill Inmon's methodology in contrast entails just having a normalized schema and doing reporting off of that. Inmon methodology is also called 3NF for Third Normal Form and this speaks to that.
No comments:
Post a Comment