XSLT Generator - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
poj1484765174891.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
Product Category
Teradata Tools and Utilities

The XSLT Generator lets you generate an XSLT that transforms documents with the structure defined by the canonical (source) schema to the structure defined by the target schema. This is done by making connections between elements in the source schema (that represent column values returned by the query used to define the canonical schema) to elements and attributes of the target schema.

Because the generated XSLT is used with the Teradata XML Services, creating a mapping to a target schema element that contains a collection of child elements results in special attributes set in the XSLT for target schema elements. One attribute,teradata_group, tells the Teradata XML Services that the source element value determines the grouping of the collection of child elements. Rows returned from the query that have the same value for the specified column create collections of child elements in the resulting XML document.

Other special attributes used by the Teradata XML Services are teradata_sort,"teradata_optional, and teradata_optional_attribues.

Option Description
XSLT Generator Status Lists target schema elements that might need values that have been mapped to a source schema element.
Clear Mappings Clears all defined mappings after you confirm the operation.
Reset Returns the mapper to its initial state after you confirm the operation.
Source Schema Displays the elements of the canonical (source) schema of the query from which the query results are mapped to the target schema.
Mappings Displays lines that connect the elements in the source schema which provide values to the elements of the target schema.
Target Schema Displays elements of the target schema which receive values from elements of the query that produces rows with the columns specified by the source schema.