While loading data from a SQL Server database into Oracle i came across a problem. Everytime i did a full load of the data i got a primary key violation in the target table. This was weird because the source did not have any duplicate keys.
It turned out to be that the bigint from the source was loaded incorrectly into the target. The following value was in the source :
The ID was processed by powercenter as :
Because the ID is truncated this causes multiple keys to be the same.
This can be fixed by setting the following option in your session:
The Bigint will now be loaded correclty.