XSLT_SHRED Shredding Mapping Definition

Teradata Vantageā„¢ XML Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

XSLT based shredding is based on a mapping defined by XSLT stylesheet documents. The stylesheet defines how different parts of the XML document map to columns in target tables in a relational database. Shredding procedures interpret the stylesheet mappings as instructions on what data items to extract from XML documents and how to use those data items in updating the target tables.

The XSLT_SHRED mapping definition is similar to the mapping definition for XSLT_SHRED_BATCH, except for the following differences.
  • genexp is a mandatory attribute for all the elements under <Row>.
  • Only the <xsl:value-of> element can be used; <xsl:copy-of> is not allowed.
  • CLOB and BLOB are not supported in XSLT_SHRED.