Handling of SCD type 2 attributes in outrigger dimension

View previous topic View next topic Go down

Handling of SCD type 2 attributes in outrigger dimension

Post  andriy.zabavskyy on Tue Sep 04, 2012 9:24 am

Let's consider the schema:
Fact Table: Contains network events
Dimension 1: Device Interfaces - physical part or device which is related to specific network event
Dimension 2 (Outrigger): Device - security device which includes device interfaces and is referenced by specific network event. Could be referenced also by other dimensions. Contains SCD type 2 attributes.

Let's suppose I design device dimension as outrigger(separate dimension table) and keep surrogate device key in device interfaces dimension as a reference.
What shall I do in case a change of type 2 occurs in device dimension and a new record is being added to device dimension? Shall I update keys in device interface dimension to point them to the current row in device dimension?

Thanks

andriy.zabavskyy

Posts : 18
Join date : 2011-09-12

View user profile

Back to top Go down

Re: Handling of SCD type 2 attributes in outrigger dimension

Post  ngalemmo on Tue Sep 04, 2012 3:01 pm

I would keep the attributes in both rather than snowflake. The type 1 would always be current. This makes it easy to report either current or point in time values.
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

- Similar topics

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