Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Jan 2000 @ 23:34:56 GMT


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


Subj:   Multi-type records in multiload
 
From:   Walt Craig

We get a file containing one or more batches of transactions. The records are arranged with a header followed by several detail records followed by a trailer record. There may be more than one batch in a given file, but the batches will always be preceded by a header and followed by a trailer. We want to MLoad the headers and trailers into one table and the detail records into another. Once a batch is loaded we will then update all the detail records with a batch identifier. It was assumed this operation would involved only ONE batch per input file. Loading these records and updating the detail records after the load is easy. Now we need to load multiple batches from one file. We can separate the batches into individual files but I would like to save that step and do this in MLoad. The host platform does not support INMODS so that is not an option. Moving the data to the UNIX platform where an INMOD is an option adds another step. I was trying to reduce the steps to one by using MLoad. Any ideas will be appreciated.


Thx

Walt Craig
Baseline Consulting Group



     
  <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: 27 Dec 2016