Change data management or incremental loading with changing data


I have a source table in Navision which contains inventory data. The data is sometimes changed back in time due to miscellaneous reasons. I have sofar handled this with change tracking in Sql Server and then I do a merge statement that either inserts new data or does an update on older data already in the fact table. 

So my question is how could I handle this in TX and do a inceremental load?


Regards Birkir


Please sign in to leave a comment.