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

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

2 posters

Go down

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

Post  kskistad 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

Back to top Go down

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

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

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

Post  kskistad 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

Back to top Go down

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

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

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

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