Volume : 5, Issue : 2, February - 2016

Flow enhancement between Customer relationship management (CRM) and Data warehouse

Prayag Tiwari

Abstract :

<p>&nbsp;&ldquo;CRM is routine that integrates ideas of knowledge management, data mining, and data warehousing so as to support an organization&rsquo;s determination-making method to maintain long term relationships with their customers. Better CRM analysis require a point by point data warehouse model that can bolster different CRM analysis and profound comprehension on CRM-related business questions. This exploration is a piece of study to analyze methodically CRM components that influence plan choices for CRM data warehouses to manufacture a scientific classification of CRM analysis and to decide the effect of those analysis on CRM data warehousing outline decisions. ETL is the center procedure of data integration and is normally connected with data warehousing. If source data taken from various sources is not cleanse, extracted, transformed and integrated in the proper way then our flow from CRM to Data warehouse will decrease. In this paper we presented advance approach by Query Cache which will increase ETL process then our flow enhancement will automatically increase.</p>