Saved Bookmarks
| 1. |
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 Example: 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. 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 Example: 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. |
|