alter row transformation in adf | alter row in azure data factory | adf tutorial part 64

[@neethishripg5667]

Hi, I am getting error in loading parquet file. Error says : does not resolve to any file. Please make sure the file/folder exists. Parquet file name contains hyphens '-' ... is this way of reading file is not applicable then. How can we read parquet file in Dataflow?

[@kirankirru9976]

how can I delete the records which are already existing in the sink? for example in the 1st run we have loaded the data into the sink from ID 1 to 6 in the 2nd run it need from the source we got to know that ID 1 is updated and ID 6 is deleted and ID 7 is inserted. In this case how can we do it?

[@ssunitech6890]

Please watch this scd type 2 video: kzbin.info/www/bejne/eKfTamOmlp12eJY

[@SS-xv6pq]

Hi, suppose we have two columns - associate id and certified status. Now the requirement is we have to only update the certified status based on associate id. How can we implement this logic? It would be really great if you provide some suggestion.

[@goluSingh-su1xs]

Totally understand

[@ssunitech6890]

Thanks 👍

[@mckreddymarupuri1]

Difference between upsert id and update if