Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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.