Archives of the TeradataForum
Message Posted: Thu, 01 Jul 2004 @ 17:47:04 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|