How to: Move Explicit Hierarchy Members by Using tblStgRelationship (Master Data Services)
In Master Data Services, you can use the staging process to change member relationships in explicit hierarchies in bulk. You can designate:
A consolidated member as a parent of a consolidated member.
A consolidated member as a parent of a leaf member.
A leaf member as a sibling of a leaf or consolidated member.
A consolidated member as a sibling of a leaf or consolidated member.
Prerequisites
To perform this procedure:
You must have permission to insert data into the mdm.tblStgRelationship table in the Master Data Services database. For more information, see Database Object Security (Master Data Services).
In Master Data Manager, you must have permission to access the Integration Management functional area.
You must be a model administrator. For more information, see Administrators (Master Data Services).
An explicit hierarchy must exist. For more information, see How to: Create an Explicit Hierarchy (Master Data Services).
To move explicit hierarchy members
Prepare the data for import into the mdm.tblStgRelationship table in the Master Data Services database. For more information and an example, see Relationships Staging Table (Master Data Services).
Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.
Import the data into mdm.tblStgRelationship. For information about importing data into a database by using SQL Server Integration Services, see How to: Run the SQL Server Import and Export Wizard.
After you successfully import the data, in Master Data Manager, click Integration Management.
In the Unbatched Staging Records pane, from the Model list, select the model that contains records you want to import.
From the Version list, select a version. The version must have the Status of Open or Locked.
Confirm that the displayed number of records matches the number of records you plan to import. If it does not, see Troubleshooting the Staging Process (Master Data Services).
Click Process unbatched data. In the Staging Batches pane, the value in the Status column changes to Queued to Run.
Note
The staging queue runs automatically at intervals based on the Staging batch interval set in Master Data Services Configuration Manager. For more information, see System Settings (Master Data Services).
The import is complete when the value in the Status column is Not Running. You can refresh the page to view the updated status by clicking Import on the menu bar.
Next Steps
To view errors that occurred during staging, highlight the batch’s row in the grid and click View details for selected batch. For more information, see Staging Error Messages (Master Data Services).
The batch remains in the queue until it is manually deleted. For more information, see How to: Clear a Batch from the Staging Queue (Master Data Services).