I have one app where we have Transaction table in day level. And many other dimension table. It is delta load from source. I need to delete one day's (past date i.e. 11 May 2016) full data and reload it again. Because for data got changed totally for that day.
If I use where clause in load statement like where date = '11/05/2016'. Is it possible to double count the data? Because we already have 5 records for that day. And I will add 5 more records. Would not be 10 records? I want to replace instead of Append.
