Archives of the TeradataForum
Message Posted: Tue, 14 Oct 2003 @ 12:41:58 GMT
| Subj: || || Re: Teradata and Informatica |
| From: || || Howard, Jack W |
I strongly suggest that you upgrade Informatica to at least 6.1 - 6.2 is the current version. In Version 6.1 Informatica integrated
TPump, FastLoad and MultiLoad utilities. We've loaded hundreds of million rows with it and have yet to have an Informatica crash due to the
newly integrated utilities. Informatica is working on additional enhancements to more tightly integrate with Teradata.
The Teradata ODBC driver on Solaris has been slow and defied tuning enhancements - Informatica's Version 5.1 made heavy reliance on it.
We internally benchmarked TPump at 9x faster than ODBC through the same Informatica workflow. Be careful when assessing Informatica if
you're using ODBC on Solaris - the issue isn't Informatica!