Archives of the TeradataForum

Message Posted: Fri, 20 Jul 2007 @ 11:34:14 GMT

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

Hi..

Thanks victor for the reply, you are right this is part of ETL tool, I came across Informatica. I never got a oppurtunity to load a very high data on teradata so I am little bit confused. Where as small amount of data they both act like one and same.

What I thought is if we use pipe line the data gets loaded as soon as it enters pipe line but fo each and every record it need to travel through network and load the data but when we enable IS STAGED, it will write to a flat file and only once this flat file need to be traveled and write the data. So what I felt was enabling IS STAGED was better( Please correct if I am wrong). But there are some cases where I came across like when this is staged is enabled than only the session success fully gets complete else it fails. So I think this IS STAGE is not just for performance sake ..right.

So I want to know what is that diffrece, I am just not able to figure it out.

Thanking you

sailesh

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