Data Warehouse Data Mart Question: Download Questions PDF
Explain What is type 2 version dimension?
Answer:
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.
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 Question | Next Question |
Explain What are Data Marts? | Explain difference between data ware house & data mart? |