canonical and non canonical data in DW design
2 posters
Page 1 of 1
canonical and non canonical data in DW design
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.
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
Re: canonical and non canonical data in DW design
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.
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.
Similar topics
» Canonical Data Model for Data warehouse
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
» Data mart design
» Data Deduplication in Dimension Design
» [b]Need Help on Employee Data Mart Design[/b]
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
» Data mart design
» Data Deduplication in Dimension Design
» [b]Need Help on Employee Data Mart Design[/b]
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum