Matching data sources RRS feed

  • General discussion

  • Hi,

    I need to think about how managing a similar problem as the following one:

    I've a centralized database on a main office, containing a Product table (ProductID + ProductDescr), and I've one or more databases for sales branch offices, containing an Orders table (OrderID + OrderDescr + FKProductID) and a Product table copy. Each month, I need to run a matching between Product table of the main office and Order table of the branch offices in order to discover possible data disalignments. For using rightly MDS, do I populate a joined table with orders and products data, or do I execute any other tasks, please?

    Any suggests to me in order to solve this issue? I'm a beginner with MDS technology. Many thanks :-)

    Monday, February 27, 2012 7:34 AM