| Dimension Table | Relationship Direction | Reason |
|---|---|---|
| Time | Unidirectional (Time → Fact) | Standard filter flow. |
| Place | Unidirectional (Place → Fact) | Standard filter flow. |
| Salesperson | Unidirectional (Salesperson → Fact) | Standard filter flow. |
| Product | Unidirectional (Product → Fact) | Standard filter flow. |
| Customer | Bidirectional (Customer ↔ Fact) | Allows filtering customers by sales events and vice versa. |
Designed and Developed by S. Rathinagiri and Gemini
In a star schema, data typically flows from the descriptive dimension tables to the central fact table. This is represented by a **single-direction relationship** (one-way pipe). The Customer dimension has a special **bidirectional relationship** (two-way pipe) that allows filters to flow back to it from the fact table, which is useful for advanced analysis like filtering customers based on specific product purchases.