Dimension with different sources (multiple business keys) ?

Page 2 of 2 Previous  1, 2

View previous topic View next topic Go down

Re: Dimension with different sources (multiple business keys) ?

Post  at710 on Mon Jun 17, 2013 5:55 am

Very interesting Topic,
since i find myself in a similar situation. Beside having different source systems (backoffice, accounting, finance) also our backoffice software contains multiple records (employee, customer, etc.) for each branch office. Lack of mandatory fields, input validation and no change tracking by the outdated backoffice solution make all potential natural keys almost useless. To add some fun every time a "prospective customer" becomes an "active customer" the backoffice system itself creates a new duplicate record with new id and no relation to the prospective... as you may guess my #1 for christmas would be a substitute backoffice solution.

however thanks for having shared your experience, hopefully it'll finally save my day(s) & good luck to all fellows struggling their way out


Last edited by at710 on Mon Jun 17, 2013 5:57 am; edited 1 time in total (Reason for editing : typo)

at710

Posts : 10
Join date : 2012-11-02

View user profile

Back to top Go down

Re: Dimension with different sources (multiple business keys) ?

Post  Mike Honey on Mon Jun 17, 2013 8:01 pm

Hi at710,

You paint a very familiar picture.  I've been working in IT for over 25 years now and if anything the design/quality of operational systems is declining, even as their scope & volume increases. 

In my youth I too would have railed at these issues - with little/no impact.  Now I am happy or even gratified to see data design/quality issues in operational systems - I now seem them as a "career opportunity" or "business opportunity". 

Who else can glean any value from such data but a DW/BI professional, following the Kimball Method?

Mike
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

Page 2 of 2 Previous  1, 2

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum