Pentaho:Global Verify:Email

← Data Quality Components for Pentaho

Input Columns

Email Address

This string value must, at the minimum, contain the basic components of an email address: two strings of text separated by a “@” character.

Output Columns

Email Address

This column returns the complete email address, standardized, and corrected according to the options selected in the Email Standardize Options.

Mailbox Name

This column returns the portion of the email address that precedes the “@” character. For “ray@melissadata.com,” this column would return “ray.”

Domain Name

This column returns the domain name from the parsed email address, minus the top level domain. For “ray@melissadata.com,” this column would return “melissadata” (without the “.com”).

Top Level Domain

This column returns the top level domain (TLD) indicator from the input email address. For “ray@melissadata.com,” this would return the “dot com” portion.

Top Level Domain Description

This column returns the official text description associated with the top level domain. Not all TLDs have a description.

Mailbox Verification Options

Express Mode

Validates the email against a database of known valid emails.

Premium Mode

Performs a real time, live validation of the email addresses.