Normalized Company Name and Normalized Manufacturer Hardware Product model
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2024 05:37 AM
Hello,
I am working on deletion of duplicate records from core_company table which has same name but different sys_id so before that whatever product models and other things attached to duplicate record i am moving to one record and updating it.
But while doing this i understood that there is normalization company table is linked as well as normalization mapping are associated with that and name of the company is being used in that table so when i am tried to update hardware product model manufacturer field which is referencing to core_company then there is another field called normalized manufactured which is holding duplicate company value.
So can anybody help me to understand how this normalized manufactures field picks value from core_company table because we have records with same name and even normalized field is set to true for both the records in core_company table as well for both the records have normalized mapping and normalization company is linked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-09-2024 08:58 AM
There are hashes in the core_company table provided by the content service; these house the updates to the companies, manufactureres-publishers from the content team. I believe the most updated hash represents the active=true company provided by the content service.
In some scenarios if you go into the NDS Normalization Data Services and complete the steps in the guided setup these duplicates will be remediated within the company table. Here is a document that might help:
If you have duplicate records
