Type 2 dimension or type 2 column?

View previous topic View next topic Go down

Type 2 dimension or type 2 column?

Post  parbie on Wed Aug 25, 2010 12:27 pm

Hello,
As a student and champion of the Kimball method within my organization, I get questions from time to time that require some research:

My data modeling tool provides "dimensional" selections, including a tab where the user can designate the type of slowly changing dimension for a given table. I like this feature from a documentation perspective and it brought up a question: Is it a best practice or "correct" to designate a dimension table as type 2 even though there is usually a mix of type 1 and type 2 columns?
For example, a customer dimension would most likely track type 2 changes on Address, City, State, Zip, etc., but would probably perform type 1 on something like FirstName, or PhoneNumber. Other than DimDate, I can't think of many dimensions (DimOrganiztion, DimProduct, DimAccount) that don't have at least some columns that could/should be type 2. Specifically the question is: If a dimension has any type 2 columns, is the dimension considered type 2? Is it more accurate to refer to a dimension as having type 2 columns? Even in more complex modeling situations where we may split out dimensions to address rapidly changing attributes, cardinality issues and other business requirements, the entire dimension still may have some type 1 columns.
Cheers.




Last edited by parbie on Wed Aug 25, 2010 12:31 pm; edited 1 time in total (Reason for editing : spelling, grammar)
avatar
parbie

Posts : 11
Join date : 2010-04-06

View user profile

Back to top Go down

Re: Type 2 dimension or type 2 column?

Post  ngalemmo on Wed Aug 25, 2010 12:46 pm

The dimension would be considered type 2, as it contains versions of dimension rows. The type defines the structure of the table, it doesn't matter how many columns have history.
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