Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Incremental Refresh on table with no dates

Hi all,   I've read all of the documentaiton on configuring incremental refresh for my import model (Azure SQL source).    How do we set this up if our table has no date/time column?   The data...
Need Help
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

the incremental refresh is intended for fact tables.

These fact tables should usually have a date column.

 

Otherwise you cannot apply the incremental refresh.