Email and Telephone numbers Validation

Yogesh Patel

Hi Everyone,

We are currently reviewing the email and telephone validation functionalities within Aperture and would appreciate further clarity on the business logic behind these rules.

Email Validation: Aperture offers two types of validation; Format Check and Domain-Level Validation.

• While Format Check verifies if the email follows a valid syntactic structure, Domain-Level validation includes format verification and performs a DNS lookup to confirm if the email domain exists. By default, the DNS server used is Google (8.8.8.8).
• However, the system often flags email addresses as having an "Invalid Domain" or "Bad Format" without providing underlying logic or specific reasons for the classification.
• Could you please share more detail on the criteria and business logic Aperture applies when validating email addresses?

 Telephone numbers Validation: Aperture supports two modes of telephone number validation; Format and Live.

• For the Format validation, we need to specify the column containing the phone numbers you want to validate, pick the country to use for phone validation and choose the validation rule (Valid phone, Valid phone region, Possible phone etc.)
• While Format Validation can flag certain numbers as invalid, the tool does not currently explain the logic or criteria for these determinations.
• For example, the system flags certain Telephone numbers as invalid, but doesn’t provide an explanation or criteria for why they’re considered invalid.
• Could you share the business logic Aperture uses for telephone numbers validation?

We’ve reviewed the documentation available under 'Data Quality user documentation | Workflows' , but were unable to locate information about the detailed validation logic applied.

We would appreciate your support in providing a clearer understanding of the rules and mechanisms Aperture uses to validate email and telephone fields.

Thanks