Archives of the TeradataForum
Message Posted: Wed, 16 Dec 2009 @ 16:16:00 GMT
| Subj: | | Re: How many Import can a multiload job have |
| |
| From: | | Victor Sokovin |
| | Out client needs to load data in over 100 spreadsheets into a Teradata table. They are all same data format. I understand Multiload can
have multiple Import steps but one infile each Import. Does anyone happen to know if there is a limit of how many Import can a Mload job have? I
read an old post saying up to 4. But I tried 5 Import in a Mload job and it works. We are in V2R6.2.2 with Multiload version
12.00.00.006 | |
I don't remember offhand how many IMPORT statements we can have in that release but in your particular case I would take advantage of the
uniform format across all files and use Joseph's FIFO suggestion:
www.teradataforum.com/teradata/20071023_220301.htm
Windows can do FIFO as well.
If you follow this route, make sure to include enough tracking information for source files so you can comfortably sort out potential failures
and restarts.
Victor
| 
