Main | Top 5 Reasons Why Data Warehouses Fail »
March 14, 2008
Data Warehousing and Corporate IT Practices
Big Corporations have streamlined IT practices to enable them to support applications in cost effective manner. many of these make sense for OLTP applications and are most likely designed so. However they will make BI development difficult.
e.g.:
BI tasks are more data intensive per transaction compared to OLTP tasks. A BI developer will need the ability to create tables on the fly, to take subset of data to analyze trends or even issues with data. An OLTP developer will likely not need this ability. Corporate policies that prevent such ability impede on the ability of BI developer to diagnose and fix problems. There are work arounds - but it is never a simple matter to backup a terabyte of data, move it across network, find a machine to handle it, and work off it. No one has such powerful machines laying around just in case....
Posted by Vijay at March 14, 2008 4:30 PM
