Procedure
-
Press F6 or click Run on the Run tab to
execute the Job.
The clients database table is filled with data from the file including upper-case last name as transformed in the job.
Results
For simple Insert operations that don't include any transformations, the use of tMysqlOutputBulkExec allows you to skip a step in the process and thus improves performance.
Related topic: tMysqlOutputBulkExec Standard properties