Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Jan 2005 @ 17:22:14 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: XML file as input for TPUMP: is it possible?
From:   Victor Sokovin

  We want to run TPUMP with an XML file as input. Is it possible? If so, how can we do that? Is there any documentation about this?  

I am not about to go check the manual but I will try to guess the answer on the basis of the following philosophy.

Teradata and especially such bulk utilities as TPUMP are meant to process large volumes of data. Therefore, there has always been a requirement to keep the input/output formats as slim as possible. Every byte matters. On the other hand, XML tags, by definition, are the opposite. They inflate the format very quickly. So, my guess is that XML is not supported at all by TD. If there are exceptions in some areas, I'll be glad to stand corrected.

  In the case that it's not possible, does anyone knows if that is planned to be possible with V2R6 or an higher version?  

I don't know but, again, I doubt.

The good news is that ETL tools tend to become more and more XML literate. They can read, write and convert XML to other formats. My experience in this area is so far only with Ab Initio. It is a good fun most of the time and only occasionally I want to throw my PC out of the window because nothing I try works. But I guess that's an intrinsic part of the XML experience.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023