Gainsight’s Load to Person action will not allow Relationship Person records to be inserted with a unique identifier if there is already a Person ID, Company ID, Relationship ID match in the dataset. This is in opposition to the way any table loads in Gainsight or outside of Gainsight. In all other systems, if the Person Match / Identifier on the Relationship Person record is unique, that is the way the system knows to insert a new record. However, in this load rule, it does not consider the identifier if there is a match on the other IDs.
Our use case: SF Associated Contacts map to Relationship Person in Gainsight. In SF, there can be multiple Associated Contact for the same Contact - Custom Object (Relationship in Gainsight) if there are unique Roles. The Roles can have different end dates, which is why unique Associated Contact records are created. Even when using the role in the Identifier, Gainsight will not mirror the Associated Contacts with the Relationship Person records. I will ultimately be creating some other type of Role object and building a rule to map a multi-select field that changes as roles are effective/ineffective, but wouldn’t it be great if this object worked like every other object in Gainsight and looked at the Identifiers?
Ref Gainsight ticket: 382585