 |
 |
Archives of the TeradataForum
Message Posted: Thu, 13 Jan 2005 @ 17:22:14 GMT
| 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.
Regards,
Victor
| |
