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.

Fig 4

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

Fig 5

Pressing the properties button will take us to the screen where we can define our script.