Pentaho:Basics: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 3: Line 3:
{{CustomTOC}}
{{CustomTOC}}


A basic Pentaho/Contact Zone Data Transform consists of an Input, a Data Transform (the MD Components), and an Output.
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.
Use the table of contents above to view more information on these topics.
Line 67: Line 67:


[[Category:Pentaho]]
[[Category:Pentaho]]
[[Category:Contact Zone]]

Latest revision as of 17:56, 10 January 2017

← 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