Pentaho/Contact Zone:Basics

From Melissa Data Wiki
Revision as of 23:46, 17 January 2017 by Admin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

← Contact Zone

← Data Quality Components for Pentaho

Pentaho/Contact Zone Basics Navigation
Overview
Tutorial
MD Components
Business Coder
Cleanser
Contact Verify
Global Verify
IP Locator
MatchUp
Personator
Profiler
Property
SmartMover
Custom Output Filter



A basic Pentaho/Contact Zone Data Transform consists of an Input, a Data Transform (the MD Components), and an Output.

Use the table of contents above to view more information on these topics.

Business Coder Component

  • Search for businesses using the phone number, stock ticker, and web address.
  • Discover business SIC codes, sales volumes, employee sizes, phone numbers, etc.

Cleanser Component

  • Standardize and cleanse data.

Contact Verify Component

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

Global Verify Component

  • Validate and Correct International Addresses
  • Supports 240 countries in the world

IP Locator Component

  • Returns geographic data for a given IP address
  • Latitude, Longitude, City, State, Zip Code, County, and ISP Information are all returned

MatchUp Component

  • Find and eliminate duplicate records
  • Enhance the efficiency and effectiveness of your database
  • Create custom Matchcodes tailored for your data

Personator Component

  • Empower E-commerce
  • Multi-sourced data sets
  • Check contact records
  • Advanced Address Correction
  • Verify individual identity
  • Flexible, Cloud-based Service

Profiler Component

  • Discovers existing weaknesses in your database (duplicates, badly fielded data, bad data, etc.)
  • Enforces business rules on incoming records at point-of-entry
  • Allows the building of metadata repository that aids in data governance and building strategic datamarts
  • Maintains data quality by continuously monitoring data after its merged into a data warehouse
  • Enforces business rules on incoming records, so you can maintain data standardization

Property Component

  • Returns information about a given parcel of property, including: assessed value; last sale price; current mortgage; physical dimensions of land; and square footage.
  • The level of detail may vary according to location.

SmartMover Component

  • Replace old addresses with move addresses
  • Identify undeliverable and incomplete addresses
  • Cut your mailing costs with postal discounts
  • Increase Postal processing and delivery