I have a table looking roughly like below which I read into QVD every morning. My problem is that sometimes the field AMOUNT is changed and I have no modification flag that show it. How can I do a insert, update, delete load ?
Case_id AMOUNT Date Function_code UserID RowID a 523,33 01-06-2012 DB 55 4
Case_id Amount Date Function_code UserID RowID
a 215,60 01-06-2012 DB 55 4
I only want to load and keep the latest value. Any ideas ?