tHMap Standard properties - Cloud - 8.0

Data mapping

Version
Cloud
8.0
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Processing components (Integration) > Data mapping
Data Quality and Preparation > Third-party systems > Processing components (Integration) > Data mapping
Design and Development > Third-party systems > Processing components (Integration) > Data mapping
Last publication date
2024-03-28

These properties are used to configure tHMap running in the Standard Job framework.

The Standard tHMap component belongs to the Processing family.

This component is available in Talend Data Management Platform, Talend Big Data Platform, Talend Real-Time Big Data Platform, Talend Data Services Platform, Talend MDM Platform and in Talend Data Fabric.

Basic settings

Open Map Editor

Click the [...] button to open the Structure Generate/Select wizard.

You can first select the type of map to create:
  • Standard Map: Map that perform mappings using functions based on xQuery
  • DSQL Map: Map that performs mappings using Data Shaping Query Language.
You can select the Don't ask me again check box to save this preference. For more information about these map types, see Working with maps.
Note: This option is available only if you have installed the R2023-10 Studio monthly update or a later one delivered by Talend. For more information, check with your administrator.

Then you can either have the hierarchical mapper structure generated automatically based on the schema, or select an existing hierarchical mapper structure. You must do this for both the input and output sides of your Map. The following lists the options for the output structure:

  • Generate hierarchical mapper structure based on the schema option: When you connect multiple output connections to the tHMap, the page displays a confirmation message that informs you that the mapper structures are generated based on the output connections.
  • Select an existing hierarchical mapper structure option: You can connect multiple outputs that are payload-based connections to the tHMap. If there is a single payload-type connection, you can select the Allow support for multiple output connections check box. The generated output map inherits from the existing payload structure.

If Talend Studio detects multiple output connections available, the window displays both output structure options without the support for multiple output connections check boxes.

If neither input nor output connection exists, the Structure Selection page is displayed.

Synchronize map with schema connections

Select this check box if you want to automatically regenerate your map's input and output structures after one of the following changes:
  • Connection metadata change
  • Input or output connection added
  • Input or output connection removed
No changes are detected when a connection is activated or deactivated.
If this check box is selected, the map is automatically synchronized when opened from the component after a change. If not, a dialog appears to ask whether you want to synchronize.
Note: For structures with multiple connections, the map can only be synchronized if the structures have the same form as the ones generated by the component configuration wizard. For example, flattening maps with multiple outputs cannot be synchronized automatically.

Map Path

Specifies the map to be executed.

If the map was automatically created using the wizard described above, this is path is set automatically.

If you want to use an existing map, click the [...] button next to the Map Path field to open a dialog box in which you can select the map you want to use, then click the [...] button next to Open Map Editor to work with the map selected. Note that this map must have previously been created in the Mapping perspective.

Read Input As

Select the radio button which corresponds to how you want the input to be read. Depending on your map, only some of the options may be available.

  • Data Integration columns (default): Use this option if you are working with Talend Data Integration metadata.

  • Single column: Use this option if you are working with Talend Data Mapper metadata.

Write Output As

Select the radio button which corresponds to how you want the output to be written. Depending on your map, only some of the options may be available.

  • Data Integration columns (default): Use this option if you are working with Talend Data Integration metadata.

  • String (single column): Use this option if the data in the output column is to be a String.

  • Byte array (single column): Use this option if the data in the output column is to be a Byte array.

  • InputStream (single column): Use this option if you are working with Talend Data Mapper metadata and the input data is a stream.

  • Document (single column); Use this option if the output column is to be a Document.

Advanced settings

Map Variable

In this field, enter a context variable that contains a path to a map. For instance, if you enter context.mymapfile, then mymapfile can point to different map files at runtime. This can be useful in cases where you want to use multiple maps without creating a new Job each time.

In the Context view, the value must be an relative path. For instance, assuming you have a map called mapA in the folder Maps/FolderA, your context variable should contain the value "FolderA/mapA.xml". You can write the path to the file with or without the .xml extension.

Note that all maps that might be referenced by the context variable must be present in the same Project. This way, when the Job is built, it will contain all candidate maps and it will be possible to switch from one to another at runtime.

For further information on working with context variables, see Using contexts and variables in the Talend Studio User Guide.

Alternate contextual Map(s)

From the drop-down list, select a map or several maps that can be referenced by the context variable added in the Map Variable at runtime.

The alternate maps selected must have the same map type (standard or DSQL) as the original map.

When the Job is built, it contains the selected alternate contextual map or maps. For an example scenario on using Alternate contextual Map(s), see Specifying a map variable and alternate map in tHMap.

Map each row (disable virtual component)

Select this check box to have tHMap process the input as a single output row. This prevents tHMap from buffering the input rows before delivering them downstream.

This can be useful, for example, when you use the tHMap component with tSAPIDocReceiver as the input component and any schema-aware component as the output component, because telling the tSAPIDocReceiver component to keep listening forever would otherwise lead to rows never being delivered.

If the tHMap is used with an input component that can remain open to continuously receive inputs, such as the tRestRequest, this option should be selected. It allows the tHMap to directly process the input received.

Emit empty payload Select this check box to send an empty row in the output connection when there is no output data. This can happen if there is no input or if the entire input is filtered out in the map. If this check box is cleared, no rows are sent to the output connection.

This option is applied only when the Map each row check box is cleared.

Use old Eclipse runtime

Select this check box to include the old Eclipse runtime in your Job.
Note: This option is available only if you have installed the R2024-03 Talend Studio monthly update or a later one delivered by Talend. For more information, check with your administrator.

Exception Threshold

Talend Data Mapper returns an execution status with an severity value which can be OK, Info, Warning, Error or Fatal. By setting the exception threshold, you can specify the severity level at which an exception is thrown, thus enabling downstream components to detect the error in cases other than the default value of Fatal.

From the drop-down list, select the severity level at which an exception may be thrown during the execution of a map.

  • Fatal (default): An exception is thrown when a fatal error occurs.

  • Error: An exception is thrown when an error (or higher) occurs.

  • Warning: An exception is thrown when a warning (or higher) occurs.

To help you diagnose problems with your map, when you test the map in Talend Studio, any errors that occur which are at warning level or above will be printed in the console window, regardless of the setting of the Exception Threshold.

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level as well as at each component level.

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.

MapExecutionStatus: returns an object of the org.talend.transform.runtime.common.MapExecutionStatus class

EXECUTION_SEVERITY: the Overall Severity numeric value. This is an After variable and it returns an integer.

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 more information about variables, see Using contexts and variables.

Usage

Usage rule

tHMap is used for Jobs that require complex data mapping from a variety of different sources.

The input and output connections can use Talend Data Mapper metadata, Talend Data Integration metadata, or a combination of the two. Each connection is independent.

When you open the Map Editor for the first time for each connection, it either generates a Talend Data Mapper structure definition based on the schema of the Talend Data Integration component, or allows you to select an existing Talend Data Mapper structure if you are using Talend Data Mapper metadata. It then creates a map with the structure selected or generated.

This component can be used in several ways:

Advanced use case
  • For the output Structure of the thMap, you can also use the WriteURL function in Talend Data Mapper . In case the output Structure of the tHMap includes both a connection to a Talend Data Integration metadata or component and a WriteURL function, the WriteURL value takes precedence. Talend Data Integration metadata or component does not receive any data from tHMap.
  • Using tHMap, you can test the generated Talend Data Mapper Map in Test Run mode.

    To use the feature, ensure that you have a compatible input document of CSV format with these properties:
    • The default delimiter is the (,) comma.
    • The system default line separator is used as the newline.
    • There is no header row in the input file.
    • There will be no header row in the output file.

    Specify your input document in Show Document > Select Sample Input Document > Select Resource/Import Document.

    To execute the transformation, click Test Run. After execution, your generated output document is in CSV format, which you can save by clicking Save to File. To configure this feature, see Test preferences.

    Tip: If you have multiple inputs and outputs in your Map, specify an input document for each row or each ReadURL map element. To execute, use the Test Run to External Output option and specify a file URL for each WriteURL in the output structure of the Map.
Limitations
  • If you created a tHMap with multiple input or output connections, you can only add new schema-based input or output connections.
  • When you add a new connection with a single column, you cannot associate it with a payload structure. The Map Regeneration mechanism only generates a single-element record for the new connection.
  • A Job containing a tHMap cannot be deployed as an OSGi bundle with the old Eclipse-based runtime.
Usage with Talend Runtime If you want to deploy a Job or Route containing a data mapping component with Talend Runtime, you first need to install the Talend Data Mapper feature. For more information, see Using Talend Data Mapper with Talend Runtime.
Note:
  • For further information about performing transformations using Talend Data Mapper , see this documentation.

  • When using representations other than Map, CSV, Avro, XML, and Cobol, running this component with the old Eclipse-based Runtime may create temporary folders, which are not automatically removed after stopping the Runtime. If you frequently run Talend Data Mapper, these files may pile up and eventually lead to a disk full error. When the error occurs, the runtime fails. To avoid this, ensure that you perform periodical cleaning. For more information, see Cleaning up temporary folders and files.