Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 16 Dec 2009 @ 16:16:00 GMT

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

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  

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:


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.


  <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