For Data Warehouse use, we are looking to use a large number of IFS views and with these views, we would want only incremental changes.
Now and for some views, there is ROWVERSION (time / date stamp) which is fine but on some of the views, the ROWVERSION is just a number (not unique) and on some views, ROWVERSION does not exist or with no available columns that could be used to identify incremental changes.
Is anybody aware of any method or mechanism that could be used in a consistent way across ‘all’ IFS views that could be used to identify incremental changes?
Any help / assistances would be greatly appreciated.