Handling of SCD type 2 attributes in outrigger dimension
2 posters
Page 1 of 1
Handling of SCD type 2 attributes in outrigger dimension
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
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
Re: Handling of SCD type 2 attributes in outrigger dimension
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.
Similar topics
» type 1 dimension - new requirements for attributes that will be updated often
» Design Standards - Numeric Type 2 Dimension Attributes
» Mini-Dimensions and Type 1 Outrigger
» dimension table design question for around 100 attributes and higher level calculated attributes
» Delete rows from an outrigger dimension?
» Design Standards - Numeric Type 2 Dimension Attributes
» Mini-Dimensions and Type 1 Outrigger
» dimension table design question for around 100 attributes and higher level calculated attributes
» Delete rows from an outrigger dimension?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum