Search code examples
dimensional-modeling

Star Schema - Loans Overdue Dates Modeling

I have a table with three columns:

  • CALC_DATE
  • LOAN_ID
  • OVERDUE_DATE

At each CALC_DATE a loan can have multiple OVERDUE_DATE. How could be modeled this table using dimensional modeling?

Solution

  • You can use a bridge table. In a classic dimensional schema, each dimension attached to a fact table has a single value consistent with the fact table’s grain. But there are a number of situations in which a dimension is legitimately multivalued. Like in your example, an loan can have many due date :

    enter image description here