I am trying to copy data from dynamic 365 to on premise sql server with the help of Azure Data Factory. The source of Copy data activity is fetch xml query with required attributes and the sink side write behavior as Upsert. It is working fine for first load.
For the incremental load some of the attributes are missing from the fetch xml response(Expected behavior due to the null values for the attributes ), In such situation upsert not update the value as null for corresponding records in sql, because these attributes are missing from the source.
So how to pass the null value into sink side upsert process? I have opted for additional columns in the source but it creates issue when there is missing attributes available for the next incremental load
Note: All columns field in the sql table accept null
Thanks in Aavance