A hierarchical mapper maps a hierarchical schema, such as the schema for an industry-standard message, to another hierarchical schema. For example, you can map the XML output of a parser data service to a target XSD file.
A hierarchical mapper loads a source schema and a target schema. It uses statements to link source elements from the source schema to target elements in the target schema. To generate a statement, you can drag a source element to a target element, or you can manually create a statement. In the statement, you define how to convert the data from hierarchical input to hierarchical output as well as define conditions and filters.
For example, you can load a source schema that represents customer invoice data in XML format and map it to a target schema that represents customer orders in XML format. You can use statements to group customer orders by month and to map contact information and order totals.
You can use a hierarchical mapper in a Data Services transformation to process hierarchical input and convert it to hierarchical output that uses a different hierarchical structure, such as converting an XML document into a different XML document or converting a JSON document into a different JSON document.
The following image shows a hierarchical mapper:
Hierarchical mapper. The mapper displays the source and target schemas. You can drag a source element to a target element to generate a statement.
Statements. Edit statement properties or add a new statement.
To use a hierarchical mapper, perform the following tasks:
Create hierarchical schemas based on the hierarchical documents, such as XML or JSON documents. For more information, see
Hierarchical schemas.
Create a hierarchical mapper to map the source schema to the target schema.
Create a mapping and select the hierarchical mapper in a Data Services transformation to process the hierarchical input and convert it to hierarchical output. For more information about creating a mapping, see
Mappings
. For more information about the Data Services transformation, see