After completing guided setup for Normalization Data Service, we noticed core_company table had duplicate entries of normalized records for same vendor.
Release or Environment
Normalization Data Services (NDS) does not normalize the core_company table. So it won't reduce core_company records where there may be duplicate names. It creates a one to many relationship between the normalized company name (cds_client_name) table that matches the name in core_company table record to Normalized mapping (cds_client_mapping) record. Then it updates the reference qualifier on select cmdb and asset related fields that reference core_company table to display the record where the name matches the value in the normalized company (cds_client_name) table.
A user can manually add many records to core_company table with same or similar name. So if "Normalized data service client" plugin is enabled and follow Normalized Data service guided setup. Then Normalized data service put the correct core_company value with column "Normalized = true". So the record with column value "Normalized = true" should be picked.
Conclusion - Multiple records can be present in the core_company table with same/similar name. If the record has "Normalized = true", then this is the only record shown when picking up the company value from the asset table. Meaning, it will only let you to select the core_company record which is normalised.