Required Sample TD script to load XML to multiple tables

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

Required Sample TD script to load XML to multiple tables

Hi  All,

Can you please help me to get sample script to load XML file into table.

I have source as XML file. I need to load the data into tables.

I have multiple repetitive blocks in XML with huge data with many columns .

I have also referred below links ( http://downloads.teradata.com/extensibility/articles/xml-query ) but unable to get proper information.

Please help me.

Thanks in advance

  • Database ( Teradata Script )
1 REPLY
Teradata Employee

Re: Required Sample TD script to load XML to multiple tables

You could store the document as an XML column in a Teradata table. Then you could potentially define an annotated schema definition that maps values to tables/column and shred the document in the database, or use XMLQUERY to retrieve specific information. (See the Teradata XML manual  B035-1140.)

 

Or you can use a third party tool to map and shred the data prior to loading. (Teradata utilities do not provide this functionality.)