Master Data Services - SSIS MDM Load

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ira Whiteside » Master Data Services - SSIS MDM Load

Master Data Services - SSIS MDM Load

Rate Topic

Display Mode

Topic Options

Author

Message

Ira Warren Whiteside

Posted Saturday, February 20, 2010 2:33 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42, Visits: 272

Comments posted to this topic are about the item Master Data Services - SSIS MDM Load

Ira Warren Whiteside

Post #869717

Stephen Hirsch

Posted Wednesday, March 03, 2010 5:28 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 09, 2013 3:53 PM
Points: 127, Visits: 85

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

Sachin Vaidya

Posted Friday, May 21, 2010 3:56 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 12:59 AM
Points: 61, Visits: 197

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

Mr.wOw

Posted Friday, October 22, 2010 4:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 3:07 AM
Points: 6, Visits: 171

That would be a Data Steward's job to commit the data after validating against the business rules.

Post #1009069

« Prev Topic | Next Topic »

Permissions