Forum Discussion
Handling of Deleted data in incremental refresh
Hi All I wanted to understand how the rows which are deleted from table are handled in incremental refresh dataset. Does it identify the deleted rows and delete from dataset OR Do we need to do ...
GilbertQ
Super User
Super UserI am not sure as it depends on your data!
Key columns: Created date, ETL Date, IsDeleted Flag.
Insert, Update, Delete is possible in any partition at any point
Table to be incrementally refreshed is a fact table
I have access to make database modificaitons if required.
Right now the only solution I can think of is to include - where IsDeleted = False, in the RLS logic for all our RLS groups.