Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Here is the code a part from Incremetal load , i could not undertand the tableName which is marked in yellow,
could you plz explain
SUB IncrementalTableLoad(tableName,TimeStampColumn)
LET tableloadStartTime=Now(1);
SET vLastExecTime=0;
SET Status =Success;
SET vTotalRecordCount = 0;
SET vRecordCount = 0;
LET pathName = '$(vIDSScriptsPath)$(tableName)$(vIDSExt)';
if not isnull(QVDCreateTime('$(vQVDPath)IDS_$(tableName).qvd')) then
LoadTime:
Load Max(LastModifiedDate) as LastModifiedDate // Or max(CreatedDate)
From $(vQVDPath)IDS_$(tableName).qvd (qvd);
Let vLastExecTime = timestamp(peek('LastModifiedDate',0,'LoadTime'),'YYYY-MM-DD hh:mm:ss');
//Let LastModifiedTimestamp = '$(vLastExecTime)';
Drop Table LoadTime;
ELSE
Call FullTableLoad(tableName);
EXIT SUB;
end if;
LET vFilter = TimeStampColumn & ' >= ' & CHR(39) & vLastExecTime & CHR(39) & ' and ' & TimeStampColumn & ' < ' & CHR(39) & vExecTime & CHR(39) ;//line added by Manoj to ensure the filter is set properly.
$(tableName):
$(Include=$(pathName))
WHERE $(vFilter);
vRecordCount = NoOfRows('$(tableName)');
if NoOfRows('$(tableName)') > 0 then
Concatenate ($(tableName))
LOAD *
FROM $(vQVDPath)IDS_$(tableName).qvd (qvd)
WHERE Not(Exists (Id));
vTotalRecordCount = NoOfRows('$(tableName)');
//RENAME table $(tableName)_TMP to $(tableName);
STORE $(tableName) INTO $(vQVDPath)IDS_$(tableName).qvd;
End If
Drop Table $(tableName);
LET tableloadEndTime= Now(1);
CALL QVDaudit('$(vQVDPath)IDS_$(tableName).qvd','IDS_$(tableName).qvd', tableloadStartTime,tableloadEndTime,vTotalRecordCount,vRecordCount,Status,vLastExecTime);
END SUB;