Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Tpump with Informatica
 
From:   Doshi, Roopali

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023