Study of Slowly Changing Dimension to Dependent Data Mart to Manage Finance Data

Financial institutions face many challenges of managing and marketing campaigns which leads in its data warehouse. The management of marketing campaign leads in dependent data mart with real time updating and recording difficulties especially when many campaigns are running parallel ways. To securing the customers from being contacted too often for sales-based marketing contacts, the concept of novelty skeleton are introduced to clamp the customers who have been targeted in Sales based campaign for a specified time period. During the novelty Frame, the customer cannot be targeted by other Sales based campaign categorized under the same channel. The introduction of novelty skeleton has increased the difficulties of campaign management and data management. The difficulties of data management include timely update and robust storage system of campaign leads. In this paper, we explained represent the concept of slowly changing dimension on dependent data mart and also studied how it can be used in the data mart of financial institutions to update and maintain marketing campaign records of customers.