<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=214761&amp;fmt=gif">
Skip to the main content.
Join Us

We are a global, distributed workforce, organized in self-managed teams.

Slowly Changing Dimensions in TimeXtender

Featured Image

TimeXtender Tuesday - Episode 22

In this episode, Wahyudi and Taylor discuss a very important feature in TimeXtender: History. More specifically, Slowly Changing Dimensions (SCD).

Think of the history feature as a "track changes" for tables. It allows you to record how data in a table has changed over time, giving you the ability to create reports that reflect how data looked at a particular moment in time.

Unlike most other data warehouse solutions, TimeXtender handles the creation and automation for SCD type 0 (ignored), type 1 (overwritten), and 2 (add new record), with just a few clicks.

If you'd like to review previous TimeXtender Tuesdays sessions, check out our TimeXtender Tuesday playlist on YouTube.

TimeXtender Tuesday Links:

Taking it further: