Comments
-
Thank you for the response. It helped. My scenario was to have a history of data with a week of delta data appened (after removing the overlap in history data). I was able to acheive this with recursive data flow. However, delete and update of a table in the dataflow was something I was not able to crack, and hence the…
-
Hello, Apologies, I have included the screenshots of individual transforms as requested. As they were simple queries i did not post them earlier, but i see your point. To reiterate, I want to update/delete the source table within the same SQL dataflow task (if there is a way). Please let me know if you need anything. Thank…
-
I have attached the screenshot of what i am trying to do. I am trying to update one row for a student_id and delete one row for a student id in the source table kvk_temo_studnet_target. After i run that process, I get 2 datasets with the name kvk_temo_studnet_target while I would like to have one kvk_temo_studnet_target…