What to watch out for
If we disable Use fast load on the options tab of the DataPump task and we try to
send data to the identity column then we can receive an error like this.
Now let's say that we create an ActiveX transformation between the
source and destination tables. We do this by removing the current transformations. We then do
Select All --> New --> ActiveX Script
We then get into a screen which has tabs to show us our source and
destination columns that we have selected
Pressing the properties button will take us to the screen where we can define our script.