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' ?
Check TPUMP manual for SERIALIZE option. By default, SERIALIZE is OFF except for "upsert".