Fact data with OLTP

View previous topic View next topic Go down

Fact data with OLTP

Post  rk1234 on 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

Thanks

rk1234

Posts : 5
Join date : 2014-07-22

View user profile

Back to top Go down

Re: Fact data with OLTP

Post  nick_white on 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.

Regards,

nick_white

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

View user profile

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