These tables have no facts. They are used to represent event tracking and coverage. Those that are used for events, relate different dimensions values at a point in time and space (e.g. encounters, orders). However, when designing such tables we add a dummy fact, which is usually called table_name_count that takes the value 1, just to make the SQL queries more clean. These tables can also be used to track coverage (for example have a fact table with one row for every test, location, day combination with a single fact denoting if it was used or not).
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 (36)
- What is RDBMS? (32)
- Tip of the day - Pushdown_sql() (20)
- Lookups in SAP BODI/DS (20)
- SAP Data Services (26)
- What is RDBMS? (25)
- List of ETL Tools (15)
- Map_Operation Transform (13)
- SCD - Slowly Changing Dimensions (10)