Incremental load

[#1]

hi,

can any body send me executable incremental load based on modified date .the data has been changing by monthly and has

deletion of rows is also there.

regards

Mahesh T

[#2]

SET QVDFILE=$(MyQvd)\QVDNAME.qvd;

TABLENAME:
SQL SELECT *
FROM SIEBEL." TABLENAME" WHERE to_char(LAST_UPD,'YYYYMMDD') >='$(vLastReloadTime)';

IF FileSize('$(QVDFILE)') > 0 THEN

TABLENAME _1:
LOAD DISTINCT
*
,ROW_ID As PK
RESIDENT TABLENAME;

DROP TABLE TABLENAME;

CONCATENATE (TABLENAME_1)

LOAD * FROM $(QVDFILE) (qvd)   
WHERE NOT exists(PK, ROW_ID)   
;

DROP FIELD PK; 

STORE TABLENAME_1 INTO $(QVDFILE);

DROP TABLE TABLENAME_1;  

ELSE

STORE TABLENAME INTO $(QVDFILE);

DROP TABLE TABLENAME;

END IF

[#3]

function used for $(vLastReloadTime)

[sundarakumar]

It should be

=ReloadTime()

-Sundar

[#5]

Let vLastReloadTime = Date(vLastReloadTime-2,'YYYYMMDD');

[Anonymous]

Hi Venkata Reddy,

Please attach me the Sample QVW file .

This will help you a lot ..