Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 19 Jul 2007 @ 11:24:44 GMT

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

Subj:   Re: What is IS STAGED
From:   Victor Sokovin

  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).  

This is probably an option within an ETL tool such as Informatica or Datastage?

I checked the MultiLoad manual of Septembet 2006, and the option wasn't mentioned there.

If it is indeed the ETL tool option then you are right about its meaning.

  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.  

If you use a pipe you also save space on your ETL sever as no intermediate file is created.

As to the performance, just try different options and see what happens in your particular case. You are supposed to be faster when you use pipes but there can be cases when the difference is not noticeable (the bottleneck is in the data export part of the process, not in the ML).



  <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