All the dimensions in our project are SCD type 2. My questions around this is Do we need to handle all the dimensions with the Interval Match logic OR Do we need to consider some aspects before doing so. Its a insurance project.
Post small example ,so people easily can understand and provide solution
Check this link..
check this thread you will an idea about the slow changing dimensions and how to use interval match with that
IntervalMatch and Slowly Changing Dimensions
Slowly Changing Dimensions
You need to understand firts what is SCD and then go through the way to handle them.
Retrieving data ...