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
