Archives of the TeradataForum

Message Posted: Thu, 01 Jul 2004 @ 17:47:04 GMT

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

Hi,

I am looking for some information on using Teradata Tpump for loading data from Informatica power center 6.1? I am looking some inputs in terms of

1) What are different way to improve load performance using Tpump for informatica sessions?

2) Is there any optimal number of 'Pack' setting for Tpump? (for Teradata with 2 Nodes ). (Like the way it is advised for Oralce and MS SQL DB for parameter commitment level)

3)Within one informatica session which is loading data to One target table, I am using one update strategy strategy for INSERT and other one for UPDATE of records. Will it slower than having only one update strategy doing UPSERT for TPump?

I appreciate your inputs.

Thanks,

Roopali

_______________________
Roopali Doshi
Menlo Worldwide Technologies- Vector Supply Chain Mgt.

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