Hot Swappable Dimensions
Hot swappable dimensions are used when the same fact table is alternatively paired with different copies of the same dimension based on the user's perspective.
For example, a single fact table containing stock ticker quotes could be simultaneously exposed to multiple separate investors, each of whom has unique and proprietary attributes assigned to different stocks. Each investor would query the shared fact table using their own specific stock dimension containing their private categorizations.
Shared Fact Table
| date_key | stock_ticker | closing_price |
|---|---|---|
| 20260101 | AAPL | 150.00 |
Investor A's Dimension (Swapped In)
| stock_ticker | proprietary_rating |
|---|---|
| AAPL | BUY |
Investor B's Dimension (Swapped In)
| stock_ticker | proprietary_rating |
|---|---|
| AAPL | SELL |