implementing Scd

View previous topic View next topic Go down

implementing Scd

Post  Ahmed Masry on Sat Dec 01, 2012 10:28 am

Can I implement an attribute in DW with (Scd Type 2) although it is implemented in the Source system with (Scd Type 1) ?

Ahmed Masry

Posts : 1
Join date : 2012-02-29
Age : 38

View user profile

Back to top Go down

Re: implementing Scd

Post  ngalemmo on Sat Dec 01, 2012 4:35 pm

Sure. That is the case most of the time. A type 2 tracks change from the point of view of the data warehouse. You detect and create historical information based on differences between what the new load contains versus what is in the dimension at the time.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum