Example XSLT Stylesheet - Teradata Vantage

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>