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

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Need Geographic Dimension

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Need Geographic Dimension Empty Need Geographic Dimension

Post  DWG Mon Apr 02, 2012 12:19 pm

Can anyone point me to a source for SQL Code to build a geographic dimension? I have found it for a date dim but not geo and it would seem like reinventing the wheel to write our own.

DWG

Posts : 1
Join date : 2012-04-02

Back to top Go down

Need Geographic Dimension Empty Re:Need Geographic Dimension

Post  hkandpal Wed Apr 04, 2012 9:58 am

Hi,

if the dimension is at the country level then the minimum you can have are the foll columns.
GEO_SKEY
COUNTRY_CD
COUNTRY_DESC
REGION_DESC


thanks

hkandpal

Posts : 113
Join date : 2010-08-16

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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