Staging samples with SP's for 2012 MDS??

Question

Basically I'm looking for a 2012 version of this:

http://sqlblog.com/blogs/mds_team/archive/2010/02/10/staging-examples.aspx

Can anyone point me to one, I have not found it, if it exists.

 

 

---

--ACG

Answer 1

Hi ACG

Have a look at the documentation here:

http://msdn.microsoft.com/en-us/library/ee633726(v=sql.110).aspx

This should answer all or most of your questions. Since the staging tables created by entity based staging are per-entity and these tables have a specific column per attribute I am not sure an example as elaborate as the one in that blog post is required. I think you will find that entity based staging is a lot simpler to work with than the old staging functionality.

Let me know if you have more questions.

Regards

Arun

---

Arunjeet Singh (Microsoft SQL Server Master Data Services)