MDS 2012 - Only Import data to final entity after manually executing in Integration Management UI

Question

How can I load data through staging tables, and only import to final entity, by manually executing on the Integration Management screen.

I am using the sp stg.udp_name_Leaf, but with this sp the data goes directly to the final entity with status = Completed

Thanks

Answer 1

When putting data into the staging tables, use the batch tag to differentiate between different sets of data. Every batch of data (identified by the unique batch tag) should show up as a separate row on the integration screen. More info here:

http://msdn.microsoft.com/en-us/library/ee633726.aspx

---

Arunjeet Singh (Microsoft SQL Server Master Data Services)