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

Fact data with OLTP

2 posters

Go down

Fact data with OLTP Empty Fact data with OLTP

Post  rk1234 Wed Sep 17, 2014 10:46 am

Hi All,

I need an best practices approach to bringing OLTP (app's) data to DW. Had a request to bring App data (have no measures) to build some user reports out by joining multiple Facts and Dimensions. The App data is not suitable for put as FACT or Dimension. What is the best approach to handle this?.

Any ideas



Posts : 5
Join date : 2014-07-22

Back to top Go down

Fact data with OLTP Empty Re: Fact data with OLTP

Post  nick_white Wed Sep 17, 2014 1:24 pm

Hi - you can always model any data as facts and dimensions, even if you have no measures you can have factless fact tables. If you need to create analytical reports (how many, how much, when, by whom, etc.) then bring the data into your dimensional model/DW.

However, if the requirement is to just print records from your OLTP system but make them look pretty (e.g. print an invoice from data coming from order header and order line tables) then I wouldn't bring the data into your DW but just report directly against your OLTP system.

If you could provide some more detail about the type of data you have in your OLTP and what reports you have to produce it would be easier for other people to make suggestions.



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

Back to top Go down

Back to top

- Similar topics

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