Upsert into MySQL Table as Sink and Excel in Blob as Source in Mapping Data Flows

Question

Hi

I wanted to Upsert into MySQL Table as Sink and Excel in Blob as Source in Mapping Data Flows.

When I am trying for Upsert,it mandatorily asks for Alter row transformation, why?

My ask is "I have key in the MySQL Table (Day,CampaignKey). I get multiple rows daily for this key. I want to update the MySQL table if the incoming Day and CampaignKey matches, else I want to insert. But what exactly needs to be given in AlterRow Transformation. Please check following screenshots

Answer 1

ADF requires you to define the rules for when you wish to update, delete, insert, or upsert rows to your destination data store. The key columns in the sink define the row matching criteria. The rule in the Alter Row tells ADF when you wish to update vs. insert vs. delete. vs. upsert. In your case, if you want to always upsert when the key columns match, then just enter true() in the upsert condition.