tStandardizePhoneNumber properties for Apache Spark Batch - 7.1

Phone number standardization

EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
Data Governance > Third-party systems > Data Quality components > Standardization components > Phone number standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Phone number standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Phone number standardization components

These properties are used to configure tStandardizePhoneNumber running in the Spark Batch Job framework.

The Spark Batch tStandardizePhoneNumber component belongs to the Data Quality family.

The component in this framework is available in all Talend Platform products with Big Data and in Talend Data Fabric.

Basic settings

Schema and Edit schema

A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component. When you create a Spark Job, avoid the reserved word line when naming the fields.

This component provides default columns. For further information, see section Default columns.

 

Built-In: You create and store the schema locally for this component only.

 

Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs.

Phone number

Select the column holding the phone numbers of interest from the input data.

Country code

Select the column holding the country codes (ISO 2) from the input data.

Note:

The input data processed by this component must be able to provide the two-letter ISO country codes alongside the corresponding phone numbers of interest.

Customize

Select this check box to set a custom country code (ISO 2). Once selected, it disables the Country code field and gives priority to the customized country code for phone number standardization.

For example, if the input data provides a set of phone numbers with a wrong country code or alternatively with no country code, then you can select this check box and type in the country code you need for standardization.

Phone number format for output

Select the format to be used to standardize the phone numbers of interest. The available options are:

- E164

- International

- National

Advanced settings

Avoid comparison

Select this check box to deactivate the comparison performed between the input and the output data at runtime. This could accelerate the execution process of the Job using this component.

Global Variables

Global Variables

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl + Space to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio User Guide.

Usage

Usage rule

This component is used as an intermediate step.

This component, along with the Spark Batch component Palette it belongs to, appears only when you are creating a Spark Batch Job.

Note that in this documentation, unless otherwise explicitly stated, a scenario presents only Standard Jobs, that is to say traditional Talend data integration Jobs.

Spark Connection

In the Spark Configuration tab in the Run view, define the connection to a given Spark cluster for the whole Job. In addition, since the Job expects its dependent JAR files for execution, you must specify the directory in the file system to which these JAR files are transferred so that Spark can access these files:
  • Yarn mode (YARN client or YARN cluster):
    • When using Google Dataproc, specify a bucket in the Google Storage staging bucket field in the Spark configuration tab.

    • When using HDInsight, specify the blob to be used for Job deployment in the Windows Azure Storage configuration area in the Spark configuration tab.

    • When using Altus, specify the S3 bucket or the Azure Data Lake Storage for Job deployment in the Spark configuration tab.
    • When using Qubole, add a tS3Configuration to your Job to write your actual business data in the S3 system with Qubole. Without tS3Configuration, this business data is written in the Qubole HDFS system and destroyed once you shut down your cluster.
    • When using on-premise distributions, use the configuration component corresponding to the file system your cluster is using. Typically, this system is HDFS and so use tHDFSConfiguration.

  • Standalone mode: use the configuration component corresponding to the file system your cluster is using, such as tHDFSConfiguration or tS3Configuration.

    If you are using Databricks without any configuration component present in your Job, your business data is written directly in DBFS (Databricks Filesystem).

This connection is effective on a per-Job basis.