Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Matching data sources

Unanswered Matching data sources

  • Monday, February 27, 2012 7:34 AM
     
     
    Sign In to Vote
    0

    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 :-)