0

In order to populate a SCD2 dimension table, a marker to note the lastest active row is always beneficial.

There are two ways I can think of 1) valid_from/valid_to 2) active_status: active/deleted

It is clear that valid_from/valid_to keeps more information, but would that complicate the ETL process a lot?

what are the prons and crons of these two methods?

Hello lad
  • 17,344
  • 46
  • 127
  • 200

2 Answers2

0

There are mainly two way to implement SCD2

1 Keep versioning . 2 Keep start date and end date for a dimension.

In most of times we use second approach with having a active inactive flag.

https://en.wikipedia.org/wiki/Slowly_changing_dimension

sandeep rawat
  • 4,797
  • 1
  • 18
  • 36
0

You'll need the from/to dates if you ever want to load historic data.

The current/active flag is just a query helper.

Ron Dunn
  • 2,971
  • 20
  • 27