There is no automated way to identify the "orphan" company records yet (which do not have SFDC references). Dependent records may be available in the Scorecard, Timeline objects, etc. You can identify "orphan" company records using the following steps:
- Add a field to Company named "Flag for Delete" (or similar). For more information on how to add a custom field in an object, see this article.
- Create two Datasets in a rule that fetches Customer Info (Acct Id and CustInfo Id) and Company (SFDC Id) respectively. For more information on how to create datasets, refer this article.
- Merge both of above datasets by SFDC Acc. Id (retaining all Company records). For more information on the merge tasks, refer this article.
- Set the delete flag where the CustInfo Id is null using the action type Load to Company.
Before deleting a record, you can also check the dependencies on this record using the Object Graph. For more information on generating an Object Graph, refer Gainsight Data Management. We recommend filing a support ticket to ensure that the accounts have been deleted successfully.
[Note: this information is based on an internal how-to conversation which we thought might benefit others in the Community!]