The data warehouse because differs, again it’s not really a database you perform data entry. You are actually collecting data from the operational loading and systems into the DWH. So the transactional processing systems just like the ERP system will be the source systems for the data warehouse. The data are fed by you in to the data warehouse. And the data warehouse collects data over a period of time typically. If you look at your transactional processing OLTP systems, such systems don’t keep quite definitely history normally. If a customer leaves or expired normally, the OLTP systems purge the info typically associated with that client and all of the transactions off the database after some amount of time. So normally once a full year most business will purge the data source of all old customers and aged transactions. In the data warehouse we save the historic data. Today because you don’t want historical data to accomplish business, nevertheless, you do need the tomorrow historical data to understand patterns of business utilization to do business, such why a person left?
In a telecommunications firm, for example, around 1 . 5 years of data is typically stored. Because there are much more call details records there are deposits and then withdrawals from a bank-account so the storage space period is less, as you cannot afford to store as a lot of it typically. Another essential point is, the additional back history you store the data, the less value it normally has. Most of the right times, the majority of the access in to the data is at that last three months to six months. That’s the most predictive data.
In retail business, retailers store at least 65 weeks of data typically. Why perform they do that? Because they would like to be able to understand this season’s selling background to last season’s selling history. For instance, if it's Eid buying time of year, I want to consider the transit-buying this Eid and compare it with the full year ago. Which means I want 65 weeks to get year going back, more a year actually? It’s a full year and a season. So 13 weeks are added to do the analysis additionally. So it depends a whole lot on the industry really. But you anticipate at least 13 weeks normally.
Emoticon Emoticon