Answer 1

The Duplicate Detection feature allows you to compare fields from different entities, but only for the purposes of duplicate detection. If you need to compare two different entities for some other purpose, you'll need to write some custom code. How you design and implement the code will depend on the purpose of the comparison.

Answer 2

Neil,

Do we have any third party tool that performs the comparison in more intelligent way rather than string comparison. I mean John Smith and Jhon Smith should be treated as same (John typed wrong as Jhon in other case). 

And also duplicate detection feature will allow to compare records of only one type of entity, in this case we need to compare records of one entity with records of other entity. 

Answer 3

A agree with Neil as we will have to tell the system about all the possible combinations otherwise it would judge.

1. An easier appoarch will be to have a report to compare all similiar record.

2. An ifame or web page showing all similar records of other entity using LIKE operator in fetch statement.

Answer 4