Hi All,
I am getting a daily full extract file with which I update a database table. I need to compare the extract file with what data is in the table and email a csv file containing all the delta or changed records.
Please suggest a design to best implement it. I was thinking of creating a temp table and then compare.
What would be the best way to implement this.
Thanks