Data Warehouse Data Mart Question:
Download Questions PDF

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.

Download Data Mart Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What are Data Marts?Explain difference between data ware house & data mart?