Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rasta Pickles
Posting Yak Master
174 Posts |
 Posted - 2015-01-27 : 14:09:05
|
| My company have started to put together a "data warehouse" for insurance based transactions.The guy in charge has deemed that only certain transactions are to be loaded into it (online quotes taken up but then not proceeded with are to be excluded, for example).My understanding of a data warehouse was that you load everything and then let the end user decide what they want to pick from.If you don't include all relevant transactions then it ceases to be a data warehouse and becomes something else, doesn't it?All comments gratefully received. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-27 : 14:10:55
|
quote:
Originally posted by Rasta Pickles
My understanding of a data warehouse was that you load everything and then let the end user decide what they want to pick from.If you don't include all relevant transactions then it ceases to be a data warehouse and becomes something else, doesn't it?
I disagree. You load whatever data you want to analyze. If they don't care about certain data, then why waste resources to load it?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2015-01-28 : 04:56:40
|
| I agree with tkizer, the hole point of DW is to have some intelligence behind it making it a usable solution for the creation of reporting needs based on the department, company and end users needs. You would create another say datamart for the online quotes as they have not been proceeded but the management team may well still want to look at these stats and understand how they fell through but this would sit within another cube for analysis. An example would be call logging where all active calls would have its own SSIS and SSAS solution and the same goes for all calls closed, these would then be reported on based on particular company needs.We are the creators of our own reality! |
|
|
|
|
|
|
Data Warehouse question