This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How to load three hundred ninety thousand files with the same format in a Teradata database. The tables are PrimaryScreen Misschargespantalla DIM chargesscreen for the load and I want to save the column and the value... how can I design it?
I'm assuming you need help processing the xml files into a table structure where one file is one row in the table? If that's correct, please see the attached example which take the file you provided and a copy of it that I've edited to test the wildcard file load. In the example, it loads the primaryscreen section of the xml but this can be changed to whatever you need via the xml parse tool.
To load to Teradata (as per Ryans answer) - use the Output data tool (Other Databases/TeraData Bulk)