Loading data using ODBC drivers thorugh Informatica

General

Loading data using ODBC drivers thorugh Informatica

Hi,

What are the essential dis-advanteages, if we load data into Terdata Table through Informatica using ODBC drivers.

I think, one of the dis-advantage is, ODBC does not perform well as native drivers...So, TPUMP may do well.

Could you please let us know, what are the other significant dis-advantages???

Thanks.

3 REPLIES

Re: Loading data using ODBC drivers thorugh Informatica

Your DBQL tables will get quite large recording single record inserts as a result of the row by row odbc connection processing within the Informatica engine.

N/A

Re: Loading data using ODBC drivers thorugh Informatica

As Goldminer said, it does row by row inserts.

The odbc is good is the table size isnt too big.

For large load, we use other teradata utilities ( fastload, mload, tpump etc)

Re: Loading data using ODBC drivers thorugh Informatica

Hi All

Can some one help on my doubts

1) How to configer TD native driver to connect TD from informatica for loading process.

2) for relational ODBC/Native connection what will be the impact if the commit point is less like 100

3) In general why relational conncetion is very slow in TD

4) If we increase the network connective will the Relational ODBC/Native /TPT etl will load faster  

Regards,

Sanjeevi