Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Master Data Services - SSIS MDM Load Expand / Collapse
Author
Message
Posted Saturday, February 20, 2010 2:33 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 1, 2014 10:40 PM
Points: 42, Visits: 294
Comments posted to this topic are about the item Master Data Services - SSIS MDM Load

Ira Warren Whiteside
Post #869717
Posted Wednesday, March 3, 2010 5:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 2:47 PM
Points: 132, Visits: 114
I have a different, I think better definition of master data. To me, master data is the result of high value transactions. For example, if Starbucks messes up a coffee order, they dump it and try again. That's not a master data transaction. However, when they buy or lease a store location, trust me, they don't throw the real estate away if they mess up the transaction.

That's master data.

Anything else is fluff and marketing hype.
Post #875855
Posted Friday, May 21, 2010 3:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 12:13 AM
Points: 75, Visits: 227
Hi,

If I have understood correctly your article shows how to populate the MDS staging tables.
From the staging tables(e.g., tblStgMember), how do I put the data into the actual MDS entities?

Regards.
Post #925794
Posted Friday, October 22, 2010 4:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 28, 2014 9:29 AM
Points: 6, Visits: 178
That would be a Data Steward's job to commit the data after validating against the business rules.
Post #1009069
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse