Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 Jul 2007 @ 09:50:46 GMT


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


Subj:   What is IS STAGED
 
From:   Yadav, Sailesh

Hi All

Friends can you please say me what is the diffrence between isstaged and non isstaged(I am talking about the option avaiable while creating external loder connection for multiload). I know if that option is not enabled than data will move into pipe line and immediately load and if it is staged than if will first write into a flat file and than after completion of load to flat file it will load into the table(Please correct if I am wrong).

I would like to know which performs faster and how. Is that option only for performance sake. And I had seen if the option is not enable in some cases the session gets failed and if it is enabled the same session starts working fine.

Any response would be greatly appritiated.


Thanking you

sailesh



     
  <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