Archives of the TeradataForum
Message Posted: Mon, 29 Mar 2004 @ 13:48:35 GMT
Subj: | | Re: Teradata Peformance issues when loading data to Teradata using ETL tools like Informatica or Data Stage |
|
From: | | Jose Lora |
Hi Rajsekhar
I'm not sure what you're asking here, but if what you need is to be able to use ETL tools and Teradata utilities, one alternative will be using
an ETL tool that allows you to send data directly from the data sources to the Teradata utilities without using staging files and allowing ETL
transformations. Hummingbird ETL provides you with that interface, I'm not sure about the other tools.
Plain ODBC or CLI connections will usually be slower than loading data with the Teradata native utilities.
Jose Lora
Senior Systems Engineer
|