Country Dimension

View previous topic View next topic Go down

Country Dimension

Post  mjak on Sun Jun 02, 2013 3:01 pm

Hi,

I have a straight forward type 1 Country dimension with just country code and name. Now we want to capture the origin of the country as well. E.g. czechoslovakia is origin country for Czech republic and Slovakia. What's the best way to handle this? Making this into Type 2 will not help as 2 records are created from 1.

mjak

Posts : 2
Join date : 2013-06-02

View user profile

Back to top Go down

Re: Country Dimension

Post  BoxesAndLines on Mon Jun 03, 2013 8:59 am

Add another column.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Country Dimension

Post  LAndrews on Mon Jun 03, 2013 12:35 pm

Great example of a type-3 SCD.

As boxesandlines suggested, you create additions colummn(s) .....

LAndrews

Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada

View user profile

Back to top Go down

Re: Country Dimension

Post  mjak on Mon Jun 03, 2013 12:51 pm

LAndrews wrote:Great example of a type-3 SCD.

As boxesandlines suggested, you create additions colummn(s) .....

But there is possible scenario of merging as well. East and West Germany merged to become Germany.

mjak

Posts : 2
Join date : 2013-06-02

View user profile

Back to top Go down

Re: Country Dimension

Post  ngalemmo on Mon Jun 03, 2013 2:49 pm

If this is a critical aspect of your data warehouse, then you can represent the political meanderings of nations as a factless fact table.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Country Dimension

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