0

Enable History on Time table

We use surrogate keys for all our joins between facts and dimensions, and since we have incrementally loaded facts, all dimensions are set to history (that's the only way to make sure the DW_Id's don't change).

For the time-table it's currently not possible to enable history, which might result in facts pointing towards the wrong time-table record.  This will happen when the user changes the start-date of the time-table and redeploys / execute the time-table.

The possibility to enable history on the time-table would resolve this issue.

3 comments

Please sign in to leave a comment.