<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Data Warehousing
»
Strategies and Ideas
»
Data warehouse - Dimensions
Data warehouse - Dimensions
Rate Topic
Display Mode
Topic Options
Author
Message
Pueee
Pueee
Posted Tuesday, August 17, 2010 4:52 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 04, 2013 4:41 AM
Points: 285,
Visits: 297
Hi
I have a question on Data warehousing - Dimension Types. I am interested to know what are different types of Dimesnions that can be used in Data warehousing.
I am aware of three different types of Dimensions -
1. Confirmed Dimension
2. Junk Dimension
3. Degenerated Dimension
Is this list correct or are there any more types? Please advice.
Thanks very much,
Puja
Post #970244
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Posted Tuesday, August 17, 2010 9:45 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:00 PM
Points: 2,988,
Visits: 4,412
PrincessPuja (8/17/2010)
I have a question on Data warehousing - Dimension Types. I am interested to know what are different types of Dimesnions that can be used in Data warehousing.
I am aware of three different types of Dimensions -
1. Confirmed Dimension
2. Junk Dimension
3. Degenerated Dimension
Is this list correct or are there any more types? Please advice.
Depending on the author you may get anything in between nine to a dozen "types" of dimensions - not to mention sub-types like Slowly Changing Dimensions of the Type 0, 1, 2 and 3.
_____________________________________
Pablo (Paul) Berzukov
Author of
Understanding Database Administration
available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #970542
Pueee
Pueee
Posted Thursday, August 19, 2010 6:28 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 04, 2013 4:41 AM
Points: 285,
Visits: 297
Thanks Paul for your reply. Great help!
Puja
Post #971807
Koen Verbeeck
Koen Verbeeck
Posted Friday, August 20, 2010 6:42 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378,
Visits: 6,473
You'll find a great explanation of the different dimension types in Kimball's book "The Data Warehouse Toolkit" (2nd edition).
Actually, to be precise, a dimension is not of SCD type 1,2,3 or hybrid, it's attributes are. A dimension can have a combination of different types of SCD. For example, the customer gender and name are SCD Type 1, but the address is type 2.
More dimensions, next to those you already mentioned:
* mini dimension
* monster dimension
(* a special table to link different dimensions with many-to-many relationships: the bridge table) --> not really a dimension
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #972477
Raunak Jhawar
Raunak Jhawar
Posted Friday, August 20, 2010 9:09 AM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946,
Visits: 1,739
You are scaring the girl!!!
Regards/Raunak
Now a member of Linkedin
Please visit the all new
Performance Point Forum
Please visit the all new
Data Mining and Business Analytics Forum
Post #972609
Pueee
Pueee
Posted Saturday, August 21, 2010 9:01 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 04, 2013 4:41 AM
Points: 285,
Visits: 297
Thanks da-zero for clarification. will read that book!
@Raunak - Every little helps!
Post #972951
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Posted Sunday, August 22, 2010 6:45 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:00 PM
Points: 2,988,
Visits: 4,412
da-zero (8/20/2010)
Actually, to be precise, a dimension is not of SCD type 1,2,3 or hybrid, it's attributes are. A dimension can have a combination of different types of SCD. For example, the customer gender and name are SCD Type 1, but the address is type 2.
Actually, to be precise, SCD types refer to the chosen method to track changes therefore they are related to the object and not to the attributes.
A hybrid SCD type 6 is nothing but the single implementation of Types 1,2 and 3 (1+2+3=6) for a specific object a.k.a. table.
Hope this clarifies.
_____________________________________
Pablo (Paul) Berzukov
Author of
Understanding Database Administration
available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #973041
Raunak Jhawar
Raunak Jhawar
Posted Sunday, August 22, 2010 9:08 AM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946,
Visits: 1,739
Type 6 SCD transformation are very very specific.
Seldom the need arises to maintain a history table.
Puja...you know my comment was on a lighter note...we allare here to help each other....
I would suggest that you familiarize yourself with...
What is fact, fact table, dimension, dimension table and most important what goes into fact/dimension table.
Once you set the right momentum...you'll find your learning curve smooth enough to model the same into advanced analytics.
Regards/Raunak
Now a member of Linkedin
Please visit the all new
Performance Point Forum
Please visit the all new
Data Mining and Business Analytics Forum
Post #973065
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Posted Sunday, August 22, 2010 4:44 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:00 PM
Points: 2,988,
Visits: 4,412
Raunak Jhawar (8/22/2010)
Type 6 SCD transformation are very very specific.
Seldom the need arises to maintain a history table.
I do not like history tables either - talking here about a data warehouse environment but, History Tables refer to a SCD of the Type 4.
_____________________________________
Pablo (Paul) Berzukov
Author of
Understanding Database Administration
available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #973119
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
