Hi folks,

after 15 months of IFS live the ITH is up to 3.4 Mio records.
That takes around 30 minutes to fetch all the data from ORACLE into MS SQL Server.

I would like to load the data incremental.

So the questions are:
Is a ITH record fix the moment it is created or could it be changed?

Is the TRANSACTION_ID “ongoing”, so we could be shure, the last (maximum)
is the latest in a row?

If so, I can easily fetch max(TRANSACTION_ID) from destination and use this as a filter
for the ORACLE fetch SQL command.

Many thanks

Michael