Incremental Load

Gaurav_Kapoor — Sun, 11 Sep 2022 17:28:49 GMT

Can you tell me that this given incremental load will give me a duplicacy ?

LIB CONNECT TO 'Microsoft_SQL_Server_192.168.1.112 (reportingserver_qsadmin)';

/*****Loading data above from MaxDate*****/
T1:
LOAD*;
SQL SELECT *
FROM "MicrosoftDynamicsAX"."dbo"."FbSalesReportAxTable"
where "Invoice Date">=DATEADD(DAY,1,EOMONTH(GETDATE(),-1));
STORE T1 into [lib://Daily QVD (reportingserver_qsadmin)/FbSalesReportAxTable $(vMonth).qvd](qvd);
Drop Table T1;
//Exit Script

/*****Concatenate Old QVD*****/
T2:
LOAD
*
FROM [lib://History QVD (reportingserver_qsadmin)/FbSalesReportAxPOSTable.qvd]
(qvd) where floor([Invoice Date])<=$(vLastMonth);

//exit Script

Concatenate(T2)

LOAD
*
FROM [lib://Daily QVD (reportingserver_qsadmin)/FbSalesReportAxTable $(vMonth).qvd]
(qvd) ;
//where not Exists([Invoice Date]);

//exit Script;

STORE T2 into [lib://History QVD (reportingserver_qsadmin)/FbSalesReportAxPOSTable_New.qvd](qvd);

exit Script

Re: Incremental Load

Mario_De_Felipe — Wed, 28 Sep 2022 06:25:45 GMT

Hi @Gaurav_Kapoor,

I think is better practice using the same condition to load the new and historic registers:

In the T1 table: where "Invoice Date">=DATEADD(DAY,1,EOMONTH(GETDATE(),-1)); why don't you use "Invoice 'Date">='$(vLastMonth)?

topic Re: Incremental Load in App Development

Incremental Load

Re: Incremental Load