Customer Relationship Management Systems Handbook

The Technology of CRM 127

for the data regardless of how frequently it is used. The data warehouse

administrator can either archive the inactive data or place it in near-line storage.

Accessing the inactive data, moving it to near-line storage, and then deleting

the data from the data warehouse makes the separation.

While it is true that all data warehouses face separation, the degree of

separation varies among warehouses, based on these factors:

 Size of the warehouse

 Type of business the warehouse supports

 Who uses the warehouse

 What kind of processing is being done

 Level of sophistication of end-user analysts

Critical Success Factors

There are three critical success factors that each company needs to identify

before moving forward with the issue ...