From: satyamrawal@yahoo.com (satyam)
Newsgroups: comp.databases.oracle
Subject: how to derive address information from User Data
Date: 6 Jun 2003 12:35:42 -0700
Organization: http://groups.google.com/
Lines: 11
Message-ID: <19466e87.0306061135.2d8fe7a7@posting.google.com>
NNTP-Posting-Host: 66.167.70.114
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1054928143 3798 127.0.0.1 (6 Jun 2003 19:35:43 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 6 Jun 2003 19:35:43 GMT


I have got a data dump which has all user information means first and
last name and Mailing address. But my Mailing Address can have missing
fields too..
I want to derive a unique Househo;d information for an individual user
with ay suppose I have following entries in my dump like:

johndoe@yahoo.com 123 main street NY NY 10101
johndoe@lycos.com 123 main street NY NY 10101


It will be helpful if you can throw any hints