Forum Discussion

rdnguyen's avatar
rdnguyen
Helper V
4 years ago
Solved

Incremental refresh

Hi All,   I have table of Part about 60K item since 1997, from which 10K of those are active. I would like to set incremental refresh based on any change / update. The problem (or I misunderstood t...
  • arvindsingh802's avatar
    4 years ago

    As your data size is only 10K, you can go without incremental
    If you still want to go with then Store rows of 30 Years or greater (so that it will keep your records from 1997)

    Refresh your data for same 30 Years or greater but check detect data change on updated column

    this way it will only update your data for updated records