In my company, we have certain master data domains like customer; Vendor; Product; Materials; Bill of Materials.
So far we have been doing our modeling using relational modeling in the cloud.
It consists of entire tables that we push from SAP ECC and SAP MDG like MARA; MVKT, etc... then we have views on top of it.
So, right now we have : Landing Zone (csv files added into this bucket); Raw Zone (Table like-to-like with SAP meaning, equal with the csv files we bring ) ; Harmonized zone (tables transformed in a way that they have only the required attributes) and on top of it , still in harmonized zone, we have views.
This is the current case for everything. Transactional and Master data
Now, we have onboarded a new vendor (someone to build a new solution inside Cloud).
They are building a new modern data platform using Cloud hence pushing transactional data as well as master data into it. Actually they will use the existing one and keep exactly same as we had the landing zone and the harmonized zone.
But they will transform the harmonized zone.
Harmonized zone will have master data and transactional data as dimensional modeling and on top of it the views.
I can understand that transactional data can be modeled as dimensional modeling mixed with master data and create dimensions and facts to serve a certain product.
But here, they defend that master data data which is separated from transactional data will be modeling in dimensional modeling.
Would it be better to have the master data as relational instead of using Master data as dimensional modeling?
Becauise multiple projects will take master data from this platform and I don't see the advantage of modeling using dimensional modeling instead of using the regular relational data model
What is your opinion on this?
Thank you very much,