We sometimes want to store identifiers coming from source systems transaction tables in the data warehouse, for purposes of grouping rows, tracking where the data come from or using them as primary keys in fact tables. We don`t create a separate dimension for these attributes as they would contain only one field, so we store them directly on the fact table and call them degenerate dimensions (for example observation id, encounter id).
All data and information provided on this blog is for informational purposes only. Opinions expressed here are entirely my own and not of my employer.
- SAP Data Services (54)
- Map_Operation Transform (37)
- What is RDBMS? (36)
- Lookups in SAP BODI/DS (25)
- Tip of the day - Pushdown_sql() (20)
- SAP Data Services (26)
- What is RDBMS? (26)
- List of ETL Tools (15)
- Map_Operation Transform (13)
- SCD - Slowly Changing Dimensions (10)