Hey there, folks,
I have decided to add a MDS using SQL
Server Master Data Services 2012 to an architecture I am working on. I have run into considerable confusion because I am not sure how to put the ETL
process. I have two ideas, which I've listed below.
Number one: Between Staging Area and DV. Doing it this way, data from DV will be extracted by the ETL
process and will be loaded into the MDS. Afterwards, data from MDS will be extracted and loaded into DV.
Number two: Between DV and Dimensional Data Store. The ETL
will extract all relevant data from DV and load it to MDS before extracting it from MDS and loading it into DDS.
Which option do you think is the best?