Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 16:03:51 GMT

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

I can tell you that at my site we do 100% of our transformations on Teradata. The operational data is Fastloaded into a staging database to which Insert/Select statements are executed against to move the data into the production databases. We have had no performance problems with this solution and feel it is more cost effective than the solution Informatica is describing, if only because it allows us to standardize on Teradata and have no other databases to support. Though this is most ideal if you have quite time on the box to do the ETL work. Obviously, if you are trying to do ETL and analytics at the same time, there will be contention. This is a site specific determination for you to make.

Also, Informatica cannot issue SQL statements against Teradata and so requires that the data be transformed in the Informatica engine and then usually Mutiloaded into Teradata. So the approach they described to you is the only one they support for loading Teradata, and it sounds better to describe it as faster. We actually decided against Informatica as our ETL tool for this reason, though it is otherwise a good product.

--Jason

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