do you do incremental load on dim_dates table?

[ioannagr]

Hello all.

Is this usual at all? Or are you guys just dropping and recreating the table every time?

Also if you do, do you use the "insert only(no update , no delete" method for incremental load?

My data looks like this. To me using datekey for incremental load looks safe.

Thank you in advance!

[Or]

Using an incremental ID will work assuming old records can't be changed, as mentioned in my previous post. If old records can be changed, then an incremental ID doesn't tell you which records have changed, only which ones are new.