Answers

Question and Answer:

  Home  Data Mart

⟩ Explain What is type 2 version dimension?

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.

 153 views

More Questions for you: