Creating an XML, XSLT, or Streaming Transformation

The steps you follow to create an XML to tabular, XSLT, or streaming transformation include:

•

Adding a New Transformation (XML, XSLT, or Streaming)

•

Adding an XSLT Transformation for a Table, a View, or a Function

•

Mapping Source Data to Target Output Columns (XSLT or Streaming) (XSLT and streaming only)

•

Adding Target Columns through the Outputs Panel (XSLT) (XSLT only)

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.

Top