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

Millions of client information that can not be uniquely identified

3 posters

Go down

Millions of client information that can not be uniquely identified Empty Millions of client information that can not be uniquely identified

Post  hennie7863 Mon Oct 19, 2009 3:14 am

Hi

Every client of an organization at which i'm employed can not be uniquely identified. In this organization 30 milions of clients per year are registered. From every client a birthname, adres, birthdate, etc is registered. In theory it's possible that double customers occur (and possibly not the same).

In my proposal i suggested that for every registration a customer is inserted into a customer dimension. So for every fact record a dimensionrecord is inserted. Of course analysis is not possible but the system is used to query on a name to see whether it occurs and how much. Operators should gather these registrations and do some manual interpretation with this information. Trying to undouble this information is faulty and when a new field is added to this dimension will give troubles because i could appear that a customer is unique on n field but not n+1 fields.

Any suggestions for a better solution?

Regards,
Hennie7863

hennie7863

Posts : 31
Join date : 2009-10-19

Back to top Go down

Millions of client information that can not be uniquely identified Empty Re: Millions of client information that can not be uniquely identified

Post  ngalemmo Mon Oct 19, 2009 11:17 am

Is this a website? Is there repeated business with these clients? What is the purpose and ultimate business value of the data warehouse?

Thing is, if the data you are getting is garbage, there isn't a whole lot you can do. Try to work with what you got, but at the same time, investigate what can be done at the source to make the data more useful.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Millions of client information that can not be uniquely identified Empty not a website but a public organisation.

Post  hennie7863 Mon Oct 19, 2009 1:16 pm

This is a public organisation which registers loans, debts and others. When a customer recieves a loan it will be registered at this organisation. Before a loan is given a customer is verified first at this organisation. For every message going in and out (XML) to and from this organisation a logrecord is created.

Thanks for your reply. I wasn't hopeful in advance.

Greetz,
Hennie

hennie7863

Posts : 31
Join date : 2009-10-19

Back to top Go down

Millions of client information that can not be uniquely identified Empty Re: Millions of client information that can not be uniquely identified

Post  BoxesAndLines Mon Oct 19, 2009 4:43 pm

If you can't uniquely identify a customer, then you can't really have a customer dimension. Any metrics at the customer level will be incorrect. If that's OK, and sometimes it is go ahead and create the customer dimension. If it's not, and most of the time it isn't, remove the customer dimension.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Millions of client information that can not be uniquely identified Empty Re: Millions of client information that can not be uniquely identified

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