Can you clearify that if I run a full load ( on a source based incremental table), it doesn't update the _I table with the current max value?
In our scenario, I run a full load very early in the morning and then run incremental loads during the day. But I have seen that the first incremental load of the day takes a very long time to run which I suspect is due to there being a lot of changes since the last incremental load, i.e. the full load's transfer is ignored by the incremental load?
So the first incremental load, more or less, transfers the same data that the full load did?
Best answer by JTreadwellView original