Archives of the TeradataForum
Message Posted: Mon, 29 Mar 2004 @ 14:58:03 GMT
Subj: | | Re: Teradata Peformance issues when loading data to Teradata using ETL tools like Informatica or Data Stage |
|
From: | | Sam Sterling |
Hi,
We use Ab-Initio, and performance is very good. Not as good as using the utilities directly, because of the power and workload on the ETL
server itself.
We have had problems where the tool would be set up to use ODBC instead of the utility interface. Also we were only using a few sessions
rather than *.
I'd check with your Informatica or Data Stage pre-sales and system engineering team and have them hook you up with other sites that are using
their tool with Teradata. I know of some pretty big shops that are using Informatica, so I'm sure they've figured it out.
|