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

[#1]

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

[#2]

Hi , you can apply the incremental load on the raw table extract into qvd. After that apply the transforms on the qvd what you are applying in sql query.