Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
in online help search for incremental
Using qvd file for incremental load, case 3, insert and update (no delete)
other useful resources
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?
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);