Difference between revisions of "SSIS:Contact Verify"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
{{SSISContactVerifyNav}} | |||
{ | |||
{ | |||
Latest revision as of 00:01, 10 November 2015
← SSIS:Data Quality Components
| Contact Verify Navigation | |||||||
|---|---|---|---|---|---|---|---|
| Overview | |||||||
| Tutorial | |||||||
| |||||||
| |||||||
|
Contact Verify Overview
Contact Verify provides the ability to verify, correct, parse and standardize addresses, phone numbers, email addresses; parse full names and detect vulgarities; and append census and geographic information like latitude and longitude coordinates.
Address Verification
- Validate and Correct US and Canadian addresses
- Append missing suites with SuiteLink® and exclusive AddressPlus technology
- Determine delivery type (business vs. residential)
- Validate and Correct non-USPS addresses
Geocoding (Spatial Processing)
- Assign Latitude and Longitude to the Rooftop
- Census Tract and Block
- CBSA Information
- County Names and FIPS
- Place Names and Place Code
Name Processing
- Parse and genderize names and multiple names
- Detect vulgarities and suspicious words in name fields
- Detect and standardize companies in the name field
Phone Processing
- Verify telephone numbers to 7 - 10 digit level
- Determine Telco Switch location
- Detect landlines vs. cellular or VOIP
- Detect Residential, business, small office/home office phones
Email Processing
- Validate and correct email domains
- Detect mobile domains (restricted from email by FCC)
- Detect bad mailbox names (spam, noreply…)
- Correct common misspellings and syntax errors