Dimension Table Verbosity - Theory verses Prictice

View previous topic View next topic Go down

Dimension Table Verbosity - Theory verses Prictice

Post  Glenn on Tue Sep 21, 2010 3:01 pm

Per Kimball "Attributes should consist of real words rather than crptic abbrevistions." and "We strive to minimize the user of codes in our dimension tables by replacing them with more verbose textual attributes." The question is IN PRRACTICE, do you typically use "Yes", "No" for values in a boolean field like Is_Work_Day, or do you spell out the data as in "Workday" or "No Work"?

Glenn

Posts : 4
Join date : 2010-07-19

View user profile

Back to top Go down

Re: Dimension Table Verbosity - Theory verses Prictice

Post  ngalemmo on Tue Sep 21, 2010 3:53 pm

Both.

Flags and codes are useful internally for ETL processing and query filtering, but end users should be presented with meaningful labels. Wither yes/no or workday/not workday depends on what the users want.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Dimension Table Verbosity - Theory verses Prictice

Post  BoxesAndLines on Tue Sep 21, 2010 5:21 pm

I have used Y/N or 1/0 for these type columns.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Dimension Table Verbosity - Theory verses Prictice

Post  Glenn on Wed Sep 22, 2010 10:36 am

OK, I think what we'll do is use the non-verbose data during the early stages of the ETL process, then present the user with the more verbose data in views. That will make it easier for us (the developers), and give the user what they want.

Glenn

Posts : 4
Join date : 2010-07-19

View user profile

Back to top Go down

Re: Dimension Table Verbosity - Theory verses Prictice

Post  Jeff Smith on Wed Sep 22, 2010 1:19 pm

I am beginning to use "Work Day" and "Non Work Day" as well as using a field called "Work Day Indicator" that is Y/N. I like using the indicator when writing code but the Text looks better in Reports and Cubes.

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Dimension Table Verbosity - Theory verses Prictice

Post  Sponsored content


Sponsored content


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