Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 15 Oct 2002 @ 22:10:55 GMT


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


Subj:   The efficient way to do it
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, October 15, 2002 09:16 -->

I have Following needs and need a expert advice.

Receive text files
Three tables will be populated
            File_Name     PK_FN_ID, .............
            HDRTRL        PK_HDRTRL_ID, FK_FN_ID, .........
            REC9201       FK_HDRTRL_ID, DUP and Details

For each pack there would be header and trailer and between them there would be detail records

First we need to make sure that each header has got matching trailor. Detail records will be within header and trailor

One file can have multiple packs

We need to populate PK's and FK's as well as DUP flag if record is duplicate This dup can reside anywhere in the pack.

THANX



     
  <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