Data Mart Philosophical Design Differences

View previous topic View next topic Go down

Data Mart Philosophical Design Differences

Post  dgorbea on Wed Sep 14, 2011 11:25 am

Hello,

I'm currently working on a project that entails developing a data mart to deliver logistics information
through SSAS cubes. My approach has been to first design a physical data mart
independent of the delivery mecahnism. SSAS cubes, SSRS reports, etc.,
will be used to deliver the data. The source system is a combination of OLTP and ODS
databases.

There's another school of thought at my current company: Rather than create a separate
physical data mart, create views over the current OLTP tables as a means of implementing
a "logical data mart", and deploying the SSAS cubes based on this logical view of a data mart.
Is this approach recognized by the Kimball Group?

dgorbea

Posts : 1
Join date : 2011-09-14

View user profile

Back to top Go down

Re: Data Mart Philosophical Design Differences

Post  BoxesAndLines on Wed Sep 14, 2011 5:48 pm

I'm not sure you'll get a response from the Kimball Group. They frequent the boards infrequently. I'll put on my un-official Kimball cap though. Bad idea for all the reasons why data warehouses started in the first place.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Data Mart Philosophical Design Differences

Post  ngalemmo on Wed Sep 14, 2011 6:07 pm

Yep. It's been done before and the end result eventually turns into a major headache.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Data Mart Philosophical Design Differences

Post  Mike Honey on Thu Sep 15, 2011 12:31 am

I agree wholeheartedly with the previous two comments.

IMO it's a particularly bad idea when feeding SSAS cubes, as there are very limited options in that tool alone for handling dirty data. Once you start pointing it at live data, this leads to frequent processing failures which are difficult to debug.

I think a solid star schema is definitely a worthwhile investment for the architecture you described.

Good luck!
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

Re: Data Mart Philosophical Design Differences

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