Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
To aggregate or not to aggregate. Multiple fact table or not ??
Thanks johnherman, This really clarifies stuff. This setup indeed offers the most flexibility. Apparently it isn't really a grain problem but more of a definition kind of problem. This setup opens up the possibility to widen the scope of the DW effortlessly. Thanks, If I have other questions...- Speediro
- Post #5
- Forum: Data Warehousing/Big Data
-
To aggregate or not to aggregate. Multiple fact table or not ??
Thx for the reply dwspecialist, A little update on the entity list. You are very right in assuming that these are the valuable entities to our management. However things are structured (nation-wide) a little differently. Entities: PATIENT->can have ONE OR MORE->REQUEST(S) REQUEST->can have...- Speediro
- Post #3
- Forum: Data Warehousing/Big Data
-
To aggregate or not to aggregate. Multiple fact table or not ??
Sketch of the problem. Medical background. Payment of treatment is based on certain 'nomenclature' (don't mind the terminology) numbers. The source system aggregates these numbers into 'Exams'. Exams are requested. Multiple exams can be requested on one request. One patient can have multiple...- Speediro
- Thread
- Replies: 6
- Forum: Data Warehousing/Big Data
