Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 29 Mar 2004 @ 14:30:30 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019