Slowly Changing Dimensions

[#1]

Hi,

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.

Regards,

Manu

[perumal_41]

Post small example ,so people easily can understand and provide solution

[Anonymous]

Check this link..

http://www.learnqlickview.com/intervalmatch-function-and-slowly-changing-dimensions/

[avinashelite]

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

[sujeetsingh]

You need to understand firts what is SCD and then go through the way to handle them.