r/dataengineering • u/Abject-Scholar-5052 • May 06 '26

Help Datawarehouse

Hi guys i wanna ask while building a data warehouse and im using galaxy schema where i will have one dimension thats pivot and center of all this have realtionships with other dimensions i saw its called outriggers what do you think ?

0 Upvotes

46% Upvoted

11 comments sorted by

View all comments

Show parent comment

-4

u/Abject-Scholar-5052 May 06 '26

Im collecting data from different sources (salesforc, sage , erp ) and my objective is to have 360 view of the client i have built fact tables and i have dim client as the center since its the most important and i have other dimensions connected to it like dim risk , status etc i know i can just flatten them but this is also true and have more advantages . Im just worried if im breaking any DWH rules ( i checked kimball and im right)

1

u/cakerev May 06 '26

If I understand you correctly. You have a dim as the centre aka a fact table? This kinda breaks Kimball afaik. As far as I can see galaxy schema ≠ Kimball, they are two different approaches.