Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 04 May 2010 @ 13:16:08 GMT


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


Subj:   Re: MLoad - Fixed Length Record
 
From:   Lipka, Paul

Hi Megan,

If the records are fixed length, and all the records are formatted the same, you should be able to accomplish this by defining multiple record layouts within the MLoad. You would have to define the record layout and insert statements for each combination or record/table.

So, basically you would assign a field in each "record type" to be used as the indicator for loading that set of data into a particular table. Your Apply statement would act as the "traffic cop" to direct the loading of tables based on the value of the indicator field you use.

Your APPLY statement may look something like this (modified to fit your needs):

     .IMPORT INFILE FILEIN LAYOUT EXTRACT_FILE  APPLY  LOAD_TBL1 WHERE FIELD_ID = 'xxxx'
      APPLY  LOAD_TBL2 WHERE FIELD_ID = 'yyyy'
      APPLY  LOAD_TBL3 WHERE FIELD_ID = 'zzzz';

Hope this helps!

Paul



     
  <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