DW Architecture for Special requirement

View previous topic View next topic Go down

DW Architecture for Special requirement

Post  virsdnana on Fri Jun 25, 2010 6:58 am

Hi,
We have a current DW/BI system that enables BI reporting and holds data for 2 years. We have a requirement from a special user group requesting to extend BI features for their purpose of reporting. However, they require 10years of data, whereas current BI environment holds only 2 as per requirements defined by majority stakeholders.

Please advice on how this scenario should be addressed? Would it make sense to come up with different Arch with Different infrastructural set up? Wouldnt this decentralize the BI? If 10yrs worth data from source is brought into current env, it may hamper the current set up as it is not designed for this.

What should be the approach for such a requirement.


virsdnana

Posts : 1
Join date : 2010-06-25

View user profile

Back to top Go down

Re: DW Architecture for Special requirement

Post  BoxesAndLines on Fri Jun 25, 2010 8:49 am

"Show me the money" should be the words right after yes we can do this. In the end, the cost will become prohibitive and the requirement will be dropped. And yes, you should redesign from the top down if your current architecture is designed to support 2 years of data.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: DW Architecture for Special requirement

Post  ngalemmo on Fri Jun 25, 2010 2:03 pm

The question I have is: What is your environment now that requires you to reconsider the architecture because you need to add more data?
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: DW Architecture for Special requirement

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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