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