Archives of the TeradataForum

Message Posted: Tue, 08 Jan 2002 @ 09:34:40 GMT

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

In a typical Data Warehousing environment, it is likely that we use ETL tools like Informatica, SAS, etc for extraction and cleansing and then using some Teradata utility like FastLoad or MultiLoad. While the data load from ETL tools like Informatica, SAS is done using ODBC, it is quite slow in execution as compared to Teradata utilities like FastLoad and MultiLoad which load data in parallel.

Use of Informatica/SAS is must as we need to extract and cleanse data frst before loading. So if we use Informatica or any other tool for extraction and then use Teradata utilities for loading, this may be the fastest solution.

Can anyone elaborate on how to use Informatica or any other ETL for extraction and cleansing while using Teradata utilities for loading in a Data Warehousing environment.

Regards

ROHIT REVO

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