Address Dimension
3 posters
Page 1 of 1
Address Dimension
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
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
RE:Address Dimension
Hi,
what happens when one Latitude and Longitude returns more than one address, is it okay or that will create problems ?
thanks
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
Re: Address Dimension
It will return only one address using latitude and longitude. Thanks
rammnch- Posts : 5
Join date : 2013-10-10
Re: Address Dimension
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
Similar topics
» Address dimension or not?
» Policy Customer/Address dimension question
» Address Dimension mapping to fact with diffrent grain
» De-normalizing Customer Information to create a Customer Dimension
» Customer and Addresses
» Policy Customer/Address dimension question
» Address Dimension mapping to fact with diffrent grain
» De-normalizing Customer Information to create a Customer Dimension
» Customer and Addresses
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|