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