Tamr Recommended Record Consolidation Rules
For each attribute in the predefined data product schema, you can choose to use the Tamr recommended record consolidation rule, as described in the tables below, or set a custom rule.
Note: In the event of a tie, the value with the least lexicographic value is selected. This means the value that comes first alphabetically is chosen. Upper case letters are of lower lexicographic value than lower case letters, so MAIN ST is of lower lexicographic value than Main St.
B2B Customers Tamr Recommended Rules
The following table describes the Tamr recommended record consolidation rules for the attributes in the B2B Customers data product.
Attribute | Tamr Recommended Rule |
---|---|
Company Name | Most common value |
Alternative Names | Pipe-delimited array of distinct values from the Company Name and Alternative Names attributes, excluding the value selected for the Company Name attribute |
Previous Names | Most common value |
Revenue | Most common value |
Company Type | Most common value |
Industry Type | Most common value |
Founding Year | Most common value |
Phone | Most common value |
Registration Number | Most common value |
Tax IDs | Most common value |
Ticker Symbol | Most common value |
Stock Exchange | Most common value |
Email Domain | Most common value |
Website | Most common value |
Associated Person | Most common value |
<AddressGroup>: Address <AddressGroup>: Address Line 2 <AddressGroup>: City <AddressGroup>: State <AddressGroup>: Postal Code <AddressGroup>: Country <AddressGroup>: Latitude <AddressGroup>: Longitude |
For all address attributes in the address group, Tamr selects the golden record values from the single source record with:
|
Custom attributes | Most common value |
B2C Customers Tamr Recommended Rules
The following table describes the Tamr recommended record consolidation rules for the attributes in the B2C Customers data product.
Attribute | Tamr Recommended Rule |
---|---|
Name Prefix | Most common value associated with the most common full name |
First Name | Most common value associated with the most common full name |
Middle Name | Most common value associated with the most common full name |
Family Name | Most common value associated with the most common full name |
Full Name | Most common value |
Name Suffix | Most common value associated with the most common full name |
Data of Birth | Most common value |
Gender | Most common value |
Most common value | |
Phone | Most common value that was successfully enriched by the Phone Number data quality service |
National ID | Most common value |
<AddressGroup>: Address <AddressGroup>: Address Line 2 <AddressGroup>: City <AddressGroup>: State <AddressGroup>: Postal Code <AddressGroup>: Country <AddressGroup>: Latitude <AddressGroup>: Longitude |
For all address attributes in the address group, Tamr selects the golden record values from the single source record with:
|
Custom attributes | Most common value |
Contacts Tamr Recommended Rules
The following table describes the Tamr recommended record consolidation rules for the attributes in the Contacts data product.
Attribute | Tamr Recommended Rule |
---|---|
Name Prefix | Most common value associated with the most common full name |
First Name | Most common value associated with the most common full name |
Middle Name | Most common value associated with the most common full name |
Family Name | Most common value associated with the most common full name |
Full Name | Most common value |
Name Suffix | Most common value associated with the most common full name |
Address Address Line 2 City State Postal Code Country Latitude Longitude Address Type |
For all address attributes, Tamr selects the golden record values from the single source record with:
|
Professional Title | Most common value |
Most common value | |
Phone | Most common value that was successfully enriched |
Alternative Phone | Most common value that was successfully enriched |
Organization Name | Most common value |
Organization Alternative Names | Pipe-delimited array of distinct values from the Organization Name and Organization Alternative Names attributes, excluding the value selected for the Organization Name attribute |
Organization Website | Most common value |
Custom attributes | Most common value |
Healthcare Providers Tamr Recommended Rules
The following table describes the Tamr recommended record consolidation rules for the attributes in the Healthcare Providers data product.
Attribute | Tamr Recommended Rule |
---|---|
NPI | Most common value |
Full Name | Most common value |
First Name | Most common value associated with the most common full name |
Middle Name | Most common value associated with the most common full name |
Family Name | Most common value associated with the most common full name |
Name Prefix | Most common value associated with the most common full name |
Name Suffix | Most common value associated with the most common full name |
Gender | Most common value |
Phone | Most common value |
Most common value | |
Date of Birth | Most common value |
Organization Name | Pipe-delimited array of distinct values from the Organization Name attribute |
Credentials | Pipe-delimited array of distinct values from the Credentials attribute |
Degree | Most common value |
Graduation Year | Most common value |
License Number | Pipe-delimited array of distinct values from the License Number attribute |
License State | Pipe-delimited array of distinct values from the License State attribute |
License Status | Most common value |
Provider Speciality | Pipe-delimited array of distinct values from the Provider Speciality attribute |
<AddressGroup>: Address <AddressGroup>: Address Line 2 <AddressGroup>: City <AddressGroup>: State <AddressGroup>: Postal Code <AddressGroup>: Country <AddressGroup>: Latitude <AddressGroup>: Longitude |
For all address attributes in the address group, Tamr selects the golden record values from the single source record with:
|
Custom attributes | Most common value |
Updated 11 days ago