roopalidoshi
MIS
Hi,
Have you worked with 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 use 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
Have you worked with 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 use 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
