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 ?

Beginner Asked on April 12, 2021 in Diyotta Studio.
Add Comment
1 Answer(s)

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.

Expert Answered on April 19, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.