While executing a job (oracle -> mysql data transfer), it is showing following error.
“Exception in component tMysqlSCD_1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `dw_product_scd`' at line 1”
It is showing error in code generated by tool.
Kindly help with the resolution of this error.
As you can see from the error, there is a problem with your MySQL synthax. THere is no way to solve the issue without looking at the SQL and probably the whole job.
Try to check what can be wrong with the SQL synthax by checking with the SQL manuals. If you cannot solve the issue you may want to export and attach the job here so I can try and test it.