Archives of the TeradataForum
Message Posted: Thu, 19 Jul 2007 @ 11:24:44 GMT
| 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).
Regards,
Victor
| 
