Difference between revisions of "Pentaho:Basics"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
{{CustomTOC}} | {{CustomTOC}} | ||
A basic Pentaho | 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]] | ||
Latest revision as of 17:56, 10 January 2017
← Data Quality Components for Pentaho
| Pentaho Basics Navigation | |||||||
|---|---|---|---|---|---|---|---|
| Overview | |||||||
| Tutorial | |||||||
| |||||||
| 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