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
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.)