SSIS:Contact Verify: Difference between revisions
Jump to navigation
Jump to search
Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..." |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{SSISContactVerifyNav}} | |||
{ | |||
{ | |||
| Line 91: | Line 39: | ||
[[Category:SSIS]] | [[Category:SSIS]] | ||
[[Category:SSIS Contact Verify]] | |||
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