상황
A veterinary clinic consolidates patient visits into an analytical data mart for health history reporting.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Modeled a single VisitFact fact table referencing six conformed dimensions to support drill-across queries
02
Used many-mandatory to one-mandatory relationships from fact FKs to dimension PKs
03
Included additive measures such as weight, temperature, and total cost in the fact table
Use this pattern when building a star schema for operational visit or event analytics where each fact row references one row in each dimension.