|
|
Archives of the TeradataForum
Message Posted: Mon, 29 Mar 2004 @ 14:30:30 GMT
Subj: | | Re: Teradata Peformance issues when loading data to Teradata using ETL tools like Informatica or Data Stage |
|
From: | | Munnangi, Rajasekhara Reddy |
Hi Lora,
I agree ODBC/CLI connections will be slower than Teradata Native Utilities. But when i am trying to load to Teradata using Informatica/ODBC
it's very very slow. Where as if run the same ETL to Oracle Target instead of Teradata using Informatica/ODBC it's much much faster. I am
wondering why this kind of difference when you are using Oracle instead of Teradata. We have tested this using various ETL interfaces under
different conditions and we found something strikingly wrong with Teradata ODBC.
Thanks,
Rajsekhar
| |