Problem

When working with addresses, it’s essential to standardize and verify them to ensure consistency. For example, the following two address records:

• 276 Pondella Road, N Ft Myers, FL, USA
• 276 Pondella Rd, North Fort Myers, FL, USA

To standardize and merge these records, you can use the PreferPrimaryValidAlias option in Reltio’s cleansing configuration.

Solution

The PreferPrimaryValidAlias option ensures that addresses like the ones above are standardized and merged into a single record. Specifically:

• When PreferPrimaryValidAlias is enabled, abbreviations (like "Rd" instead of "Road" or "Ft" instead of "Fort") are standardized, and the records are merged.
• Without this option, abbreviations like "Ft" will not be converted to "Fort."

How It Works:

• When PreferPrimaryValidAlias is enabled, the system checks for valid aliases and uses the preferred format for addresses, ensuring consistency across all records.

Additional Resources:

For more details on address standardization and cleansing options in Reltio, refer to the following documentation:

• Address Standardization