Recently, had a Query Regarding ODS, Datamart or a Datawarehouse?
And it was backed having as datawarehouse is the best. But my Call was IT DEPENDS,yes Indeed it just Depends. Further analysis led us to a Campaign managment System built over an ODS - operational Data Store.
These different systems are built for specific purpose to meet the objectives. They absolutely address different purpose in their own way.
Following are the examples where these systems should be Build.
ODS - possibly for Call Centres or CRM systems having a recent snapshot of the Data
Datamart - Historical Data for a Department in Enterprise viz. Sales, marketing, Risk
Datawarehouse - These systems are Built with a purpose to provide a picture of the Enterprise with respect to time based on factual data.
A CRM and a Campaign management programme could be a derivative of any of the above; as stated earlier, depending what are the KPI's and Objectives of the Project.
Hence objectives of the Project and KPI's after distilling the requirements are responsible for choosing the right system to serve the organisation.
No comments:
Post a Comment