XSLT Shredding Mapping Definition | XML Data Type | Teradata Vantage - 17.10 - XSLT Shredding Mapping Definition - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)

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 the input XML documents and how to use those data items in updating the target tables.

Example XSLT Stylesheet

The following shows the syntax of the stylesheet mapping.

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/">
 <Transaction>
  <OPERATION>                 ///Insert/Update/Delete/Upsert
   <Table>
    <TABLE NAME>             ///Table name in which to store the shredded values
     <xsl:for-each select="PATH">     ///Sub-tree path to iterate the shredding
      <Row>
       <xsl:copy-of select="ELEMENT PATH"/> ///ELEMENT PATH in XML sub tree
                           OR
       <COLUMN><xsl:value-of select=" ELEMENT PATH "/></COLUMN> 
                                     ///COLUMN is a column name in target table
      </Row>
     </xsl:for-each>
    </TABLE NAME >
   </Table>
  </OPERATION>
 </Transaction>
</xsl:template>
</xsl:stylesheet>