Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 15:33:00 GMT


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


Subj:   Load order of Fast Load Utility
 
From:   Alexander T

I'm using the fast load utility for loading into a table from flat file.But I'm having some problem

The fast load utility according to me actually sorts the records before inserting into the table, but this is not what i need

i want the first record to be taken in.

For eg : If I have table with columns say

     Column1 numeric primary key,
     Column2 numeric ,
     Column3 numeric

And the sample file i use for loading is :

     10,30,50
     10,40,20
     10,20,60

And if I use the fast load utility then it inserts the row 10,20,60 to the database and rejects the other two records since its with the same primary key value 10.

Here if you see , though is the 3rd record it is the one which gets inserted instead of 10,30,50 which is the first record.

Is there any option to tell the fast load utility that insert the records in the order it comes ?

Because what i need is the records getting inserted in the order it comes in the file.

so if you have any records which have duplicate primary keys, i want the first record to be inserted and the others rejected.

Please help.


Regards

Alexander



     
  <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