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

Address Dimension

3 posters

Go down

Address Dimension Empty Address Dimension

Post  rammnch Thu Oct 10, 2013 10:40 am

Hi We are in the process of designing conformed address dimension. What should be the key for address dim?  We want to use Latitude and Longitude to locate the address. The below are the fields we have in mind to use it for addr dim. Your inputs are greatly appreciated. Thanks

ADR_TYP_CD  
ADR_TYP_DSC
LINE_ADR_ONE
LINE_ADR_TWO
LINE_ADR_THR
FULL_ADR    
APT_ADR    
CITY_ADR    
DIR_ADR    
QDRT_ADR    
ST_NUM_ADR  
ST_RURL_ADR
ST_ADR      
SFX_ADR    
UNIT_ADR    
ZIP_CD      
ADR_LIST_FLG
EFF_BEG_DT  
EFF_END_DT  
ETL_ISRT_DT
ETL_UPDT_DT
ETL_PROC_ID
ADR_EFF_BEG_
ADR_EFF_END_
DEL_SEQ_IND
MAIL_ADR_FLG

rammnch

Posts : 5
Join date : 2013-10-10

Back to top Go down

Address Dimension Empty RE:Address Dimension

Post  hkandpal Thu Oct 10, 2013 1:20 pm

Hi,

what happens when one Latitude and Longitude returns more than one address, is it okay or that will create problems ?

thanks

hkandpal

Posts : 113
Join date : 2010-08-16

Back to top Go down

Address Dimension Empty Re: Address Dimension

Post  rammnch Thu Oct 10, 2013 1:56 pm

It will return only one address using latitude and longitude. Thanks

rammnch

Posts : 5
Join date : 2013-10-10

Back to top Go down

Address Dimension Empty Re: Address Dimension

Post  ngalemmo Thu Oct 10, 2013 2:42 pm

Typically, the natural key for an address dimension is the address itself.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Address Dimension Empty Re: Address Dimension

Post  rammnch Thu Oct 10, 2013 3:45 pm

Thanks for the replies. Can any one provide me how the address dim is designed in your organizations and what are the scenarios to consider while developing address dim. Thanks

rammnch

Posts : 5
Join date : 2013-10-10

Back to top Go down

Address Dimension Empty Re: Address Dimension

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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