Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

canonical and non canonical data in DW design

2 posters

Go down

canonical and non canonical data in DW design Empty canonical and non canonical data in DW design

Post  selmak Sat Mar 19, 2011 7:42 pm

Hello,
I wanna know what is the real impact of representing canonical and non canonical data in a star schema.
I read that fact tables must have atomic data only. What about dimensions? Can they represent non atomic data, why and in what cases?
Thank's in advance.

selmak

Posts : 1
Join date : 2011-03-19

Back to top Go down

canonical and non canonical data in DW design Empty Re: canonical and non canonical data in DW design

Post  ngalemmo Mon Mar 21, 2011 11:43 am

Sure, dimension need not be atomic, in fact there is no notion of 'atomic' dimension tables.

By their nature they are almost always denormalized and their natural keys may be compound business keys. In fact, a junk or 'mini' dimension is made up of left over attributes so its natural key is simply the concatenation of its attribute values.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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