Multi-valued domain matching
Posted: Wed Apr 10, 2013 11:57 am
I'm not sure if the post title is accurate. Maybe that is why I'm not getting any search hits.
We have a requirement to match on attributes that can have multiple values, e.g., the multiple contacts below
Reference Set -
Company A, Contacts {Person A, Person B, Person C}
Company B, Contacts {Person D, Person E}
Data Set -
Company A, Contacts {Person B}
The desired result is that Company A should match based on the Person B contact. I'm not exactly sure how to accomplish this. Exploding the reference set so that there is a record per Person seems unreasonable. Would using a vector or subrecord column type be the correct approach? The documentation seems a little confusing.
Any input is appreciated.
We have a requirement to match on attributes that can have multiple values, e.g., the multiple contacts below
Reference Set -
Company A, Contacts {Person A, Person B, Person C}
Company B, Contacts {Person D, Person E}
Data Set -
Company A, Contacts {Person B}
The desired result is that Company A should match based on the Person B contact. I'm not exactly sure how to accomplish this. Exploding the reference set so that there is a record per Person seems unreasonable. Would using a vector or subrecord column type be the correct approach? The documentation seems a little confusing.
Any input is appreciated.