Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 22 Jul 2004 @ 16:42:06 GMT


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


Subj:   Re: MLOAD of a file with multiple record types
 
From:   Nomula, Madhukar

The file is pipe delimited.

The file format is:

     |3001|something|something|1234|456|
     |3002|gerbage|abcjndsf;sd|sldfjsd|ldfjsdklgf|sjdfsdkgvsd;|
     |3003|dfsfndsfn|dsfnsdln|
     |3004|sd;f;ds|
     |3005|zsdfgnsd;fj|lsdmfn|sdlmfnsd;nf|lsdzfnds;|lsdncs;dfn|sdfnds;fn|zsdn;dsnf|

The file i have has the record type format shown above. I needed to read that file into 5 layouts depending on the first field. Then load it into 5 tables. I just seperated the file into 5 files and loaded it but since the file is 7 gigabyes, it's taking lot of space.

Is there any way to load it using multiload.


Madhukar.



     
  <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: 23 Jun 2019