tXMLMap operation

tXMLMap is fine-tuned to leverage the Document data type for processing XML data, a case of transformation that often mixes hierarchical data (XML) and flat data together. This Document type carries a complete user-specific XML flow. In using tXMLMap, you are able to add as many input or output flows as required into a visual map editor to perform, on these flows, the operations as follows:

• data multiplexing and demultiplexing,

• data transformation on any type of fields, particularly on the Document type,

• data matching via different models, for example, the Unique match mode (related topic: Using Explicit Join),

• Automated XML tree construction on both of the input and the output sides,

• inner join and left outer join (related topic: Using Inner Join)

• lookup between data sources whatever they are flat or XML data using models like Load once (related topic: Handling Lookups),

• fields concatenation and interchange,

• field filtering using constraints,

• data rejecting.

Like tMap, a map editor is required to configure these operations. To open this map editor, you can double-click the tXMLMap icon in the design workspace, or alternatively, click the three-dot button next to the Map Editor in the Basic settings view of the tXMLMap component.

tXMLMap and tMap use the common approaches to accomplish most of these operations. Therefore, the following sections explain only the particular operations to which tXMLMap is dedicated for processing the hierarchical XML data.

The operations focusing on hierarchical data are:

• using the Document type to create the XML tree;

• managing the output XML data;

• editing the XML tree schema.

The following sections present more relevant details.