How to use Informatica and Teradata support tools for DW

[rohitrevo]

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.

 

[Guest_imported]

Thought you might like to know that SAS has a product called Access to Teradata which provides native access to the Teradata tables and automatically calls the FastLoad utility under the covers. This makes it a heck of a lot faster than the ODBC access you are currently using.

It uses the usual libname engine, much like the Access to DB2 and Access to Oracle products so the tables look like normal SAS ones.

Check out

http://www.sas.com/service/news/feature/19feb01/teradata.html

for more details

 

[usatish]

rohitrivo,

Informatica, has support to invoke teradata utilities. what it does is writes the data to text and invokes the teradata utilities to load it further.
As suggested by namder SAS/ACCESS has the native support to Fastload utility only and fastload can load data only in empty tables.
Similary, datastage also has some supports for terdata. It gerenates the control file w.r.t load utility, writes data from source to text file and then invokes the load utility to load in TD.

TIP: most of such utilities uses comma,semi colon etc saperated intermidiate text files, but your data from source might also contains these characters. So check for the option to provide a delimeter in this files.

usatish