0

Change data management or incremental loading with changing data

Hi,

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

4 comments

Please sign in to leave a comment.