how to deal if field value change in historical data

[venkey2847]

Hi All,

I have an one table  it contains historical data like beow

Composite primary key(Combination of 3 fields)	A	B	C
123	1	2	3
010	0	1	0
345	3	4	5
231	2	3	1
678	6	7	8
976	9	7	6
843	8	4	3

one of field value changed means if field value of A is 2 but it is changed by 5 like several field values has changed.

If we do   incremental load, it needs to be updated with the 5 instead of displaying 2records( i.e. 2 and 5) instead of displaying 231 it needs to be updated with the 531.

the historical data was changed.

please help me out this issue.

If anything requires more to understand question please let me know...

Thanks in advance..

Thanks & regards

venkey.

[sunny_talwar]

Is this the field you used to determine if a record has been updated or deleted or is there another field to do that? If the Key field itself is changed, then that could be a problem.

[venkey2847]

thanks for your reply..

yes that field only we are using to update..

give me any suggestion please

Thanks

venkey