Explain What is type 2 version dimension?
Submitted by: AdministratorVersion 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
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
Read Online Data Warehouse Data Mart Job Interview Questions And Answers
Top Data Warehouse Data Mart Questions
☺ | Explain What is data validation strategies for data mart validation after loading process? |
☺ | What is data mart? |
☺ | Explain What are Data Marts? |
☺ | Explain difference between data ware house & data mart? |
☺ | What is difference between drill & scope of analysis? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |