InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 21:05:24 GMT20http://www.sqlservercentral.com/Forums/Topic970244-363-1.aspx[quote][b]Raunak Jhawar (8/22/2010)[/b][hr]Type 6 SCD transformation are very very specific.Seldom the need arises to maintain a history table.[/quote]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.Sun, 22 Aug 2010 16:44:43 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic970244-363-1.aspxType 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.Sun, 22 Aug 2010 09:08:04 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic970244-363-1.aspx[quote][b]da-zero (8/20/2010)[/b][hr]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.[/quote]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.Sun, 22 Aug 2010 06:45:38 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic970244-363-1.aspxThanks da-zero for clarification. will read that book!@Raunak - Every little helps!Sat, 21 Aug 2010 09:01:26 GMTPueeehttp://www.sqlservercentral.com/Forums/Topic970244-363-1.aspx:-D:-DYou are scaring the girl!!!Fri, 20 Aug 2010 09:09:10 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic970244-363-1.aspxYou'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 dimensionFri, 20 Aug 2010 06:42:22 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic970244-363-1.aspxThanks Paul for your reply. Great help!PujaThu, 19 Aug 2010 06:28:38 GMTPueeehttp://www.sqlservercentral.com/Forums/Topic970244-363-1.aspx[quote][b]PrincessPuja (8/17/2010)[/b][hr]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 Dimension2. Junk Dimension3. Degenerated DimensionIs this list correct or are there any more types? Please advice. [/quote]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.Tue, 17 Aug 2010 09:45:25 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic970244-363-1.aspxHi 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 Dimension2. Junk Dimension3. Degenerated DimensionIs this list correct or are there any more types? Please advice. Thanks very much,PujaTue, 17 Aug 2010 04:52:46 GMTPueee