5 Replies Latest reply: Nov 3, 2014 7:43 AM by Mahesh CJ RSS

    Help!! Incremental load and store data quarterwise

    Mahesh CJ

      Hi,

       

      Below is my requirement:

      I have 3 Tables in my DB

       

      // Contains the below fields. Create and modify operations happen on this table:

         Master_Table:

         Transaction_ID, Transaction_Date, Partner_Code, Partner_Name, SKU, DB_Create_Date, DB_Modified_Date;

       

      // Customer defined Fiscal Calendar  

         Fiscal_Calendar:

         Start_Date, End_Date, Fiscal_Month, Fiscal_Quarter, Fiscal_Year;

       

      // Contains all the Purged Transaction from Master_Table

         Purge_Table:

         Transaction_ID, Transaction_Date, Partner_Code, Partner_Name, SKU, DB_Create_Date, DB_Modified_Date;  

       

      I'm trying to achieve the below:

      Incremental Load that supports:

      1. Should extract and store Data Quarter-wise, Like Master_Data_2014Q1.qvd, Master_Data_2014Q2.qvd;

      2. If there is any new record Create or Record Update in any Quarter the incremental Load should handle the same and store it back to respective Quarter QVD.

      3. Should check for new Records in Purge_Table and remove the same from Respective Quarter QVD.

       

      Thanks for helping in advance.