Data Warehouse Data Mart Interview Question:

Explain What is type 2 version dimension?

Submitted by: Administrator

Version dimension is the SCD type II in real time it using because of it will maintain the current data and full historical data.

In scd type 2 we have flag, version and timestamp..Type 2 reveals about contain historical and current data.. Whenever the current data get's in version was change.. for eg: em id 1000 is staying in chennai it is v1, when his location changed to bangalore v2, again to delhi v3.. remember its only for em id 1000.
Submitted by: Administrator