Creating an XML, XSLT, or Streaming Transformation
The steps you follow to create an XML to tabular, XSLT, or streaming transformation include:
Adding target output columns is optional.
XSLT Transformation Limitation
The Data Map panel of the XSLT transformation does not display input fields for tables, views, and functions. Because the XSLT transform requires that the object being transformed has a Schema to generate Input Fields for the object.
TDV automatically generates a schema for XML-File data sources and WSDL data sources.
XML to Tabular Mapping
This transformation accepts an XML or WSDL source as input, and generates a tabular mapping to the elements in the source schema.
The mapping can be thought of as producing a set of rows, each of which represents a node in the original XML document. The XML document is converted into a table that represents the document’s data and nodes, as described in the following table.
Column Name | Column Type | Description |
id | INTEGER | Unique identifier for an element or attribute value. |
parent_id | INTEGER | Unique identifier for the parent of this element. |
depth | INTEGER | Number of elements in the path. |
name | VARCHAR | Local name of the element or attribute. |
xpath | VARCHAR | Xpath expression that fully describes the location of the element or attribute. |
path | VARCHAR | Path to the element or attribute. The path consists of a forward-slash-separated list of enclosing element names, ending with the local name of the element or attribute. |
position | INTEGER | Position of this element relative to the path attribute. |
value | VARCHAR | Value of the element or attribute. |