How to handle bad zip codes

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
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
See also
more_less
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"