Home Forums Data Warehousing Strategies and Ideas Is it wrong to look at MDS as a type of DWH? RE: Is it wrong to look at MDS as a type of DWH?

  • March 4, 2015 at 8:35 am

    #1781666

    I have one more scenario to expand this further:

    SourceSystem has Persons of type Applicant and test scores for each applicant.

    The persons would be pushed into MDS for sure, but MDS is not a place for scores (IMO).

    So any system downstream that wants to use at Applicants and scores will have to:

    1. pull the applicant data from MDS.

    2. Once they have the Applicant data, they then pull the score data from the source system (or DWH if present).

    is that the correct way to approach that problem?