Incremental load

[#1]

Hi,all i want to increment the data to my QVD based on updated data ,it means new records will join to old ,

here based on Value_date i want to upload but problem is some record are missing when i create QVD ,now am uploading that missing record that are same Value_date ,can any one give simple script for this,

this is my Script

LOAD

    Txn_Date,

     Value_Date,

     Description,

     ChequeNo,

     Year(Value_Date) as Used_year,

     Month(Value_Date) as Used_month,

     Day(Value_Date) as Used_day,

     Debit,

     Credit,

     Balance

FROM

[..\Data\Qvd\sbi.qvd]

(qvd);

[its_anandrjs]

Create a Max date variable like and then use it for incremental load for updated records in the database

LET vMaxDate = Peek('Value_Date',-1,'YourTableName');

YourTableName:

LOAD

    Txn_Date,

    Value_Date,

    Description,

    ChequeNo,

    Year(Value_Date) as Used_year,

    Month(Value_Date) as Used_month,

    Day(Value_Date) as Used_day,

    Debit,

    Credit,

    Balance

FROM

[..\Data\Qvd\sbi.qvd] (qvd);

Left Join

LOAD

    Txn_Date,

    Value_Date,

    Description,

    ChequeNo,

    Year(Value_Date) as Used_year,

    Month(Value_Date) as Used_month,

    Day(Value_Date) as Used_day,

    Debit,

    Credit,

    Balance

FROM

[Source Data] Where Num(Value_Date) > $(vMaxDate);