Selection, Clean up and Transformation
You can use the Selection/transformation module to select, clean up and transform the source data before transmitting it to the target or in the target itself.
It is possible to choose the machine where you want the processor to be consumed.
There is virtually no limit to the transformations you can perform.
When the selection/transformation is executed on the source machine, the objective is to transmit towards the target only what is necessary in the desired format. It is also possible to access the data and the code of the machine and of the source database.
Inversely, when the transformation takes place in the target, it is possible to access the data and the code of the machine and of the target database.
The code runs on the source machine so that only required data in the correct format is transmitted to the target.