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 :-)
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.