Jeff Smith at 18h09
22
Sep
2010
How to handle bad zip codes
My company acts as a third party vendor. A new cleint does not want us to cleanup geographic information that comes they send to us. 2 things happen as a result. 1) we can get multiple spellings for the same city, and 2) we can get Zip Codes that do not exist in the corresponding city or even state.
I have a Zip Code Dimension table that I load from an outside source. The source has the Zip Code, City, State, and County. In the Zip Code
My company acts as a third party vendor. A new cleint does not want us to cleanup geographic information that comes they send to us. 2 things happen as a result. 1) we can get multiple spellings for the same city, and 2) we can get Zip Codes that do not exist in the corresponding city or even state.
I have a Zip Code Dimension table that I load from an outside source. The source has the Zip Code, City, State, and County. In the Zip Code
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
I have a invoicing warehouse with two fact tables. First is an invoice header fact table which reports on invoice totals and includes a surrogate key for a stat code that was assigned to the invoice. The grain is one row per invoice. Next is a part
Here are some codes.
Name:
Code: setshield 2k1police-shield.png
Status:
Description:
_________________________________
Name:
Code: setshield 6axe-shield.gif
Status:
Hi all.
I have a dimension with 35+ million records as compared to 225 Million in the fact table. I am not sure about the kind of penalty we will have to pay for such a big dimension. Here is summary regarding this dimension.
This dimension is derive
Hi All,
I am in
process scripting using C# in Selenium RC for we application. While browsing
the application I come across different dialog box e.g. dialog box with option
Save and Cancel, window to select file to upload any file
Hello all,
I have a situation that I am unsure how to handle and would appreciate some input.
My operational system allows me to add, edit and remove customers. My source operational system also constrains me from adding a cusomter with the same nam
Forums from same category
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
LEGO Island Discussion, modding, news and more!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
HmongThoobNtiajTeb. com/
Search
Informations
1 Replies For the topic :
"How to handle bad zip codes"
This topic has been viewed 660 times.
Last message :
22/09/2010 at 18h09 by "Jeff Smith"






