TPUMP Behaviour

Tools & Utilities
Not applicable

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' ?

Teradata Employee

Re: TPUMP Behaviour

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