Hello All,
We are planning to implement Company Normalisation through NDS. Currently, the Core Company table has several duplicates (name duplicates). These duplicate names are already in use across several classes in CMDB.
Based on the testing in lower environments, only one of these duplicate company records is getting normalized. So, even after normalization, the existing CI records that reference the duplicate company records continue to point to non-normalized company value.
Could you suggest the best approach to handle the duplicates in company table and the recommended way to update the existing CIs, so they reference the correct, with non-duplicated value.
