I have just started reading about Increamental reload, and I understand some parts about, but I am not really sure how it works, can some one help me with a simple example of increamental load on the attached file?
I am loading data from the SQL database, and I only want to load new data that has been added to the table, the issue is that, i am loading millions of rows to the model and i want to avoid loading all the data when doing a reload but only loading the new rows
On my case the ADD ONLY LOAD will not work since the data i want is only the new added data on sheet1, I want to add the Data that was inserted on sheet1 after I did the first reload. what I see now is that if I do the reload on the same sheet, all the data is add again, plus the new rows.
So is there a way to load only the new data but on the same sheet?