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

Is it possible to design a DW in parallel with its source systems?

3 posters

Go down

Is it possible to design a DW in parallel with its source systems? Empty Is it possible to design a DW in parallel with its source systems?

Post  nick_white Wed Jul 16, 2014 2:43 am

Hi,
I have come across the following scenario a few times in my career and was wondering what people's views are on how to approach it:

Scenario
Your company/client has a greenfield project and/or is undertaking a platform replacement program; so new CRM/Transactional/Finance/ERP systems are being designed and built, and business processes will change due to the enhanced capabilities of the new systems - and the company also wants a brand new data warehouse/reporting platform.
The program managers, who are not experienced data warehouse people (and you wouldn't expect them to be), plan for all systems to go live on the same day and therefore plan for all systems to go into UAT, Sys Test, etc. on the same day.

From a DW perspective, when you start on day 1 the only requirements the users/SMEs can give you are in terms of the existing platform/processes and so may not be relevant on the new platform, and none of the source systems exist - so no physical data model to analyse and no data available to profile.

While you can obviously do some initial investigations and get your processes in place and agreed, I don't believe it is possible to develop a DW in parallel with its source systems being developed; and if you try you are liable to have to do a significant amount of re-work at a later date.

Do people agree?
If they do, how far behind source system build should the DW build lag? Start Dev when source systems move to Test, or UAT, or Prod, or 3 months after go-live?
If DW development lags behind source system development, is it reasonable for the program managers to expect DW to catch-up at some point and still deliver to Prod on the same date as the source systems? If so, at what point in the development cycle would you have expected the DW to have caught up?

nick_white

Posts : 364
Join date : 2014-01-06
Location : London

Back to top Go down

Is it possible to design a DW in parallel with its source systems? Empty Re: Is it possible to design a DW in parallel with its source systems?

Post  ngalemmo Thu Jul 17, 2014 2:30 am

I first got into a situation like that in parallel with an SAP implementation. At the time I told myself I never want to get into a situation like that again. But, in the 15 years or so after that, I keep running into similar situations. It's a real pain. You basically struggle with incomplete and vague information for about 70% of the project and things don't start crystalizing until about 90% of the way through. Chaos ensues and somehow everything gets done.

It's not the best way to do it. There is a lot of revisions, and revisions to the revisions. Frankly, I would rather come in after the operational system design is solid, but it never seems to work out that way.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Is it possible to design a DW in parallel with its source systems? Empty Re: Is it possible to design a DW in parallel with its source systems?

Post  BoxesAndLines Thu Jul 17, 2014 2:10 pm

I've been on projects like this as well. You do the best you can do given the fluctuating source database design. The biggest pain is taking all the extra time to document why the reporting model is late for the PHB's.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Is it possible to design a DW in parallel with its source systems? Empty Re: Is it possible to design a DW in parallel with its source systems?

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