Abstract
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.
Highlights
The Financial institutions generate huge volume of data daily due multiple transactions and operations
Robust and wellmanaged data Mart that stores and tracks customer contacts history which can assist in effective campaign management
In prospective 1 and 2, where fresh leads which were not targeted in past campaigns and existing leads which were out of novelty skeleton will be successful uploaded onto Data Contact History Table (DCHT)
Summary
The Financial institutions generate huge volume of data daily due multiple transactions and operations. Type 3: Type 3 SCD updates the record by creating new dimensions to the table structure. The type of SCD to implement largely depends on the Some other variables/fields could be introduced to the business and institutional requirements with table for tracking purpose. SCD TYPE 2 SCD Type 2 puts new the effective start date, the effective end date, and the record to the existing available dimension table and convenient flag.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have