Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 15:36:24 GMT

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

<-- Anonymously Posted: Thursday, December 05, 2002 10:22 -->

Hi,

I have been told by some Informatica ETL experts that loading Fact data (Transaction data) in Teradata is slow when we want to apply some transformations on the data.

The faster approach they say is to stage the data in some other database (we have oracle here), apply transformations in the staging and then load the transformed data to Teradata. (We are in the process of moving our warehouse from Oracle to Teradata).

I believe we can do transformations using Teradata Procedures and reduce the extra hop of data.

I need your comments on this issue.

Thanks.

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