Need clarification on below scenario.
I have party entity (ID, FirstName, LastName, FullName, CompanyName, Birthdate, SSN), address entity (ID, Address_1, Address_2, City, State, Zip) and party_address (ID, party_id, address_id, address_type). Party and address are not directly linked but through this party_address.
Now I know that we can create match rule using columns of related entity. But in this scenario how do I use Address attributes to create a match for Party?
Hi
The best practice is to avoid such modeling, as it unnecessarily complicates processing. The first step is to reconsider your model, at least at the instance level, to include a direct link from the address to the party.
If you're certain that you need this model, you can still move the necessary data from the address to the party using the "Copy Columns" option. First, copy the address data from the address to the party_address using the "Copy Columns from Parent → Child" relationship setting. Then, copy the newly created column from party_address to the party using the "Copy Columns from Child → Parent" setting.
Using CDI Example it could look like following:
First copy values from Contract (address in your case) to the relation table
And then copy the new column from the relation table to party:
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.