Honestly, it's my first time using this, and I can't find much documentation.
Currently, I have partial loads configured using WHERE clauses with date or NOT EXIST clauses for IDs, but it takes just as long as a full load. Sometimes the data even increases, and I don't understand why.
Could someone please review my code and tell me if it's correct?
it seems you are using ADD Only in partial load statement, that's why data is increasing as its getting appended to old loaded data. if you want to use partial reload to override data, then you should use keyword Replace instead of ADD.
