3 Replies Latest reply: Mar 10, 2014 3:55 AM by Colin Albert RSS

    Incremental load in qvd's

    vijeta sharma

      Hi everyone,

      I am facing problem in incremental load within qvd's,

      my scenario is first time i am doing full load but in next month i want to load only new records and last six months data among which some of the old records are updated how should i do?

        • Re: Incremental load in qvd's
          Massimo Grossi

          in online help search for incremental

          Using qvd file for incremental load, case 3, insert and update (no delete)

           

          other useful resources

          Incremental Load

          Incremental Load.docx

           

           

           

          • Re: Incremental load in qvd's
            vijeta sharma

            My script is,

            SET vExecTime=0;

            SET v6MonthsBack=0;

            t1:

            LOAD LastModifiedDate

            FROM D:\Qvds\cnt.qvd(qvd) ;

            LET vExecTime=Peek('LastModifiedDate',0,'t1');

            LET v6MonthsBack=AddMonths('$(vExecTime)',-6);

            Table1:

            LOAD Max(LastModifiedDate) as MDate from D:\Qvds\cnt.qvd

            Where LastModifiedDate < $(v6MonthsBack);

            concatenate

            SQL select * from dbo.country_info where LastModifiedDate > $(v6MonthsBack) and LastModifiedDate < $(vExecTime) ;

            STORE Table1 into D:\Qvds\cnt.qvd(qvd);

             

            It's giving me an error

            Cannot open file 'D:\Qvds\cnt.qvd

            Where LastModifiedDate < 7/3/2013' The filename, directory name, or volume label syntax is incorrect.

             

             

            Table1:

            LOAD Max(LastModifiedDate) as MDate from D:\Qvds\cnt.qvd

            Where LastModifiedDate < 7/3/2013 what's this mean?

              • Re: Incremental load in qvd's
                Colin Albert

                I think there is a space missing before (qvd)

                 

                My script is,

                SET vExecTime=0;

                SET v6MonthsBack=0;

                t1:

                LOAD LastModifiedDate

                FROM D:\Qvds\cnt.qvd (qvd) ;

                LET vExecTime=Peek('LastModifiedDate',0,'t1');

                LET v6MonthsBack=AddMonths('$(vExecTime)',-6);

                Table1:

                LOAD Max(LastModifiedDate) as MDate from D:\Qvds\cnt.qvd

                Where LastModifiedDate < $(v6MonthsBack);

                concatenate

                SQL select * from dbo.country_info where LastModifiedDate > $(v6MonthsBack) and LastModifiedDate < $(vExecTime) ;

                STORE Table1 into D:\Qvds\cnt.qvd (qvd);