1 Reply Latest reply: Dec 20, 2013 9:53 AM by Srikanth P RSS

    How to reload qvd incrementally from multiple source(joined) table

      Hi all,

      To find out how incremental reload and storing into a QVD file works from the result of sql include multiple tables ( 3 tables)..

       

      Here is the data sql what i want to do incremental reload and store;

       

      SELECT  P1.PROMOTION_NO,

              P3.STORE_ID,

              P2.PRODUCT_NO,

              WT.DATE ,

              TRUNC(P2.UPDATE_DATETIME) as PD_UPDATE_DATETIME,

              TRUNC(P1.UPDATE_DATETIME) as PT_UPDATE_DATETIME,

              TRUNC(P3.UPDATE_DATETIME) as PB_UPDATE_DATETIME   

        FROM PROMOTION_DEFINITION P1,

             PROMOTION_DETAIL P2,

             PROMOTION_STORE P3,

             WATSONS_CALENDAR WT

      WHERE P1.PROMOTION_NO = P2.PROMOTION_NO

         AND P1.PROMOTION_NO = P3.PROMOTION_NO        

         AND WT.DATE BETWEEN P1.SALE_START_DATE AND P1.SALE_END_DATE

       

           TABLE SUMMARIZE:

      • in  Promotion_def table  promotion_no is unique and  generated by sequence ..
      • in promotion_detail   table  later new products can be added to a promotion or existing ones can be deleted
      • in promotion_store table   later  new stores can ve added to a a promotion or existing ones can be deleted..

       

      Note: all table have an update_datetime column.

       

      According to informations above.. how  can i  get  only new  and updated rows  from datasource ( database).

       

       

      I hope someone can explain the me.

       

      Kind regards,

       

      Gökhan ÇELİK