Dealing with "alias" names in a dimension
2 posters
Page 1 of 1
Dealing with "alias" names in a dimension
Maybe this is a simple problem, but I just can't seem to get my head around it.
I have a "location" dimension that stores a location name and attributes related to a "location". Over time, a location can be assigned additional names ("aliases"). When users query my DW based on location, I want to let them query either by the original location name, or by any aliases that may have been created over time. I don't really care when additional "aliases" were created, I just want to let users query by the original location name or by any aliases.
This doesn't seem to fit into a normal "type 2" SCD situation since I really don't want to partition history based on when an alias was assigned -- I just want to show all current + history under the particular alias chosen by the user. I do know that I don't want users to accidentally double-count because they've inadvertently picked a location twice (by accidentally picking multiple aliases for a single location).
Anyway, can anyone give me some advice on how to deal with this? Thank you in advance.
I have a "location" dimension that stores a location name and attributes related to a "location". Over time, a location can be assigned additional names ("aliases"). When users query my DW based on location, I want to let them query either by the original location name, or by any aliases that may have been created over time. I don't really care when additional "aliases" were created, I just want to let users query by the original location name or by any aliases.
This doesn't seem to fit into a normal "type 2" SCD situation since I really don't want to partition history based on when an alias was assigned -- I just want to show all current + history under the particular alias chosen by the user. I do know that I don't want users to accidentally double-count because they've inadvertently picked a location twice (by accidentally picking multiple aliases for a single location).
Anyway, can anyone give me some advice on how to deal with this? Thank you in advance.
dbaker- Posts : 1
Join date : 2012-08-24
Re: Dealing with "alias" names in a dimension
Use a separate structure with alias and natural key, or alias and type 2 key (and the maintenance process to support it). Or you can put limits on the use of aliases and simplify things.
Similar topics
» Dealing with Duplicate Dimension Rows
» Names of levels in Hierarchy
» Dealing with multiple many to many related type2 SCDs
» Dealing with Mergers
» difference between alias and duplicate tables in OBIEE
» Names of levels in Hierarchy
» Dealing with multiple many to many related type2 SCDs
» Dealing with Mergers
» difference between alias and duplicate tables in OBIEE
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum