All Forums Tools
madhu.sigdel 1 post Joined 08/12
10 Aug 2012
TPUMP Behaviour


How does TPUMP behaves if we have 2 rows with same UPI key in flat file?

Is there any method it choose order of data while executing tpump?

I have flat file with data as:


ID | Name

1 | A

1 | B


When tpump is executed, the value obtained in target table is random between these 2 value. 

Is this the behaviour of tpump? Shouldnt it perform in order and give value as 'B' ?


Fred 1096 posts Joined 08/04
11 Aug 2012

Check TPUMP manual for SERIALIZE option. By default, SERIALIZE is OFF except for "upsert".

You must sign in to leave a comment.