We have duplicate data in entities in Master data services and not in staging tables. how can we delete these? We cannot delete each row because these are more than 100?
Master Data Services deleting rows from UI
1.4k views Asked by Durga At
4
There are 4 answers
0
On
Did you create a view for this entity? see: https://msdn.microsoft.com/en-us/library/ff487013.aspx Do you access to the database via SQL Server Management Studio? If so:
- Write a query against the view that returns the value of the Code field for each record you want to delete.
- Write a query that inserts the following into the staging table for that entity: code (from step 1), BatchTag, ImportType of 4 (delete)
- Run the import stored proc EXEC [stg].[udp_YourEntityName_Leaf] See: https://msdn.microsoft.com/en-us/library/hh231028.aspx
- Run the validation stored proc see: https://msdn.microsoft.com/en-us/library/hh231023.aspx
MDS comes out-of-the-box with two front-end UIs:
You can use both of them to easily delete multiple records. I'd suggest using the excel plugin.
Are there any Domain-based attributes linked to the entity you're deleting values from? If so, if the values are related to child entity members, you'll have to delete those values first.