Degenerated Dimension: The dimensions which are available in the fact table without having any attributes to it or not having different dimensional table for it, e.g. year
Conformed Dimension: The dimensions which are being used in more than one star schemas, e.g. date dimension being used in inventory as well as purchase schema
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment