Bus Matrix - Business Process -to- Source System not 1:1?

View previous topic View next topic Go down

Bus Matrix - Business Process -to- Source System not 1:1?

Post  kskistad on Wed Feb 10, 2010 4:36 pm

We have a number of source systems that all do the same thing- receive loan applications. The reason for multiple systems is because some are web-based, some are for B2B, and some are legacy.

So, do we list three separate Business Processes on the Bus Matrix for each of these systems, or just one, because they all do the same thing- collect applications?

kskistad

Posts : 11
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Bus Matrix - Business Process -to- Source System not 1:1?

Post  ngalemmo on Wed Feb 10, 2010 5:11 pm

The purpose of the bus matrix is to model the fact/dimension relationship in the data warehouse. Unless you plan to have separate sets of fact tables for each source (NOT a good idea) then it should appear once.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Bus Matrix - Business Process -to- Source System not 1:1?

Post  kskistad on Wed Feb 10, 2010 6:06 pm

Thanks. The reason I was unsure was that Kimball mentions 1st-level data marts usually are from a single source system.

kskistad

Posts : 11
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Bus Matrix - Business Process -to- Source System not 1:1?

Post  ngalemmo on Wed Feb 17, 2010 1:57 pm

It's best to avoid that, particulary if the information is basically the same. You may want to include a source system dimension (aka channel) in your fact table so that source can be identified.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Bus Matrix - Business Process -to- Source System not 1:1?

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