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

Fri, 20 Dec 2013 11:04:19 GMT

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

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

Fri, 20 Dec 2013 14:53:38 GMT

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.

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

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

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