The problem we have is the source system does not capture changes. Therefore, we receive the entire data file each week. We drop and recreate the tables each time. They...
Thank you both for your help and feedback. Especially for the resources. I have three different sources with different process flows. I will probably do this for each of them...