Unable to view the Upsert option in the Mysql target
I’m trying to perform UPSERT operations into the Mysql target. I couldn’t find UPSERT as load type in the target attribute mapper. My dataflow type is generic. The source I’m using is SQL SERVER. How do I perform the UPSERT operations on MySQL target ?
For this specific use case, you can try loading your data from the source [SQLSERVER] into a temporary table in the MYSQL database through dataflow. Then perform the UPDATE/UPSERT operations on the actual target table using the DBCMD present in the jobflow.