A subdimension is a secondary dimension table linked to a dimension table. Although we try to have all the related attributes of a dimension in a single table, there are some sets of attributes that are used again and again in many dimensions. The same way that dimensions are used as an entry point in fact tables, subdimensions are used as an entry point in dimensions. The most usual subdimension is the date dimension, for example a last encounter date in a patient dimension.
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? (35)
- Lookups in SAP BODI/DS (23)
- Tip of the day - Pushdown_sql() (20)
- SAP Data Services (26)
- What is RDBMS? (25)
- List of ETL Tools (15)
- Map_Operation Transform (13)
- SCD - Slowly Changing Dimensions (10)