Normalization was not enabled previously, so core_company is having duplicate data. Across all tables in servicenow this data of core_company is used and so is having inconsistent data all over. Is there any way to rectify these duplicated data which is previously there or I have to run script over all the tables, find the duplicate data and replace the values in each and every record with actual sys id of the record.
