Normalization Process in Core Company Table

[monica190]

Hi team, I have a question about normalization. For example, if I create a record in the Core Company table with a random name that includes "Apple" as a suffix, and normalization is enabled in my system, OOB the normalized value for the Core Company record would be set to "true." I’d like to understand the process by which values in the core_company table are normalized. How does my record get normalized to "Apple"? Is there an automated process involved?

[Nilesh Pol]

Hi @monica190 

Upon instantiation of a new model record, normalization automatically runs, regardless of whether you manually create it, import it, or discover it. 

The model is compared against the data in the Hardware Normalization Content Service. Match criteria is based on Manufacturer, model Name, and Model number. The model is fully Normalized if the information is available.

[monica190]

Hi @Nilesh Pol 

Thanks for the reply, but that's not what my question is. My question is, for eg

if a record for cisco systems is created in the core_company table, the normalized field is set to true by default OOB. However, since this record does not exist in the normalization mapping table, it is not being normalized to Cisco Systems, Inc.

My questions are:

1. If third parties create records in the core_company table that are aliases of existing companies (e.g., cisco systems as an alias for Cisco Systems), how does the normalization process handle them? 

2. What is the correct process to ensure that new records in the core_company table are properly normalized when they match alias company names in the normalization mapping table?

[Nilesh Pol]

@monica190 

1. When third parties create records in the Core Company table that are aliases for existing companies, the normalization process needs to match the alias (e.g., "cisco systems") with a standardized name (e.g., "Cisco Systems, Inc."). HOW? - When a record (e.g., "cisco systems") is inserted into the Core Company table, the normalization engine checks if this value has an alias match in the normalization mapping table.

2. Update the Normalization Mapping Table - Make sure that all known aliases for existing companies are added to the normalization mapping table.

[Sagar Rd]

HI @Nilesh Pol & @monica190 

I do have the similar issue, I have a company record by the name A2iA (Normalized Company Name) and along with the I am able to see A2iA Corporation as the Normalized Company mapping under the able (cds_client_mapping). Now I have manually created a new company record with the name A2IA CORP, as soon as I created the Hash value is generated, but it don't added to the A2iA (Normalized Company Name) or any of the mapping is created. Why it did not create the mapping any idea or thoughts for this.

Thank you