8 Replies Latest reply on Nov 6, 2019 2:07 AM by Purushotham G K

MDM 10.3 - How to not to match records within same source system

Rahul Yadav Sep 22, 2019 8:34 AM

We have the project requirement for which we do not want to match record within the same source if specific requirement met. e.g.

We have sources S1, S2, and S3. We also have a Party table with Party type values 'INDIVIDUAL' and 'BUSINESS'. As per requirement, we would like INDIVIDUAL records (Party Type = 'INDIVIDUAL') not to match within the same source system. But individual records can match across the source systems - S1, S2, and S3. However, records with Party Type = 'BUSINESS' can match within the same source system as well as across source systems.

How can we achieve this in Informatica MDM 10.3?

1. Re: MDM 10.3 - How to not to match records within same source system

yadagiri palla Sep 23, 2019 8:02 AM (in response to Rahul Yadav)

Hi,
Might the below thing has some workaround but as an option you can think of.
You need to create two match rule sets with filter condition on party type as INDIVIDUAL and BUSINESS. Before running INDIVIDUAL match set just enable distinct on source system S1 and when you run BUSINESS match set disable distinct on source system S1. Include your party type in rules.
Like Show 0 Likes(0)

Actions
2. Re: MDM 10.3 - How to not to match records within same source system

Anuvinda Kulkarni Sep 23, 2019 11:02 AM (in response to Rahul Yadav)

Hi Rahul,

I agree to the workaround provided by Yadagiri. It seems like the only way is to create 2 different match rulesets. Enable Filtering on the match rulesets accordingly and enable/disable distinct on source system accordingly.
Like Show 0 Likes(0)

Actions
3. Re: MDM 10.3 - How to not to match records within same source system

Shriharsha Manjunath Sep 24, 2019 4:44 PM (in response to Rahul Yadav)

Distinct source system enabling is a better option so that the records from the same source system will not get matched.
Like Show 0 Likes(0)

Actions
4. Re: MDM 10.3 - How to not to match records within same source system

Rahul Yadav Sep 24, 2019 5:15 PM (in response to Rahul Yadav)

@Yadagiri, Anuvinda - How can we enable and disable distinct for every job execution? Is that something be passed as a parameter while executing a match job?
Like Show 0 Likes(0)

Actions
5. Re: MDM 10.3 - How to not to match records within same source system

yadagiri palla Sep 24, 2019 11:59 PM (in response to Rahul Yadav)

We have to disable indicator (DISTINCT_SYSTEM_IND) in c_repos_distinct_system. You can write a small piece of code for this and call before & after that match or use etl mapping to do that.
Like Show 0 Likes(0)

Actions
6. Re: MDM 10.3 - How to not to match records within same source system

Ajay Kumar Sep 25, 2019 9:30 AM (in response to Rahul Yadav)

Hi Rahul,

You can also think of loading the individuals as one source and business as second source. That way you can mark one source as distinct source and other as non-distinct.

This is a best practice too as the individuals and business from a source needs to be treated differently.

Regards,
Ajay Kumar
Like Show 0 Likes(0)

Actions
7. Re: MDM 10.3 - How to not to match records within same source system

Anshul Jain Sep 30, 2019 5:22 AM (in response to Rahul Yadav)

Distinct System Configuration is available in the Match/Merge's tab where you can make the source as immutable and they will not match to themselves. Refer the Configuration Guide for exact configuration.
Like Show 0 Likes(0)

Actions
8. Re: MDM 10.3 - How to not to match records within same source system

Purushotham G K Nov 6, 2019 2:07 AM (in response to Rahul Yadav)

Marking the source systems as distinct will help you in achiving this.
Like Show 0 Likes(0)

Actions