Pentaho:Basics

From Melissa Data Wiki
Jump to navigation Jump to search

← Data Quality Components for Pentaho

Pentaho Basics Navigation
Overview
Tutorial
MD Components
Contact Verify
Global Verify
IP Locator
MatchUp
Personator
SmartMover
Custom Output Filter



A basic Pentaho 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.

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

IP Locator Component

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

Global Address Component

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

MatchUp Component

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

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

Personator Component

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