Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Who can post a simple incremetal load script (insert only)
Thank you
The Help could.
QV_Table:
SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
WHERE ModificationTime >= #$(LastExecTime)#
AND ModificationTime < #$(BeginningThisExecTime)#;
Concatenate LOAD PrimaryKey, X, Y FROM File.QVD;
STORE QV_Table INTO File.QVD;
Does this help?
Hi
Hope this is helpful
You will have to use the below statement to get rid of duplicate records.
WHERE NOT exists(PrimaryKey);
Table1:
SQL SELECT PrimaryKey, A, B, DateTimeField FROM DataBaseTable
WHERE DateTimeField >= $(LastExecTime);
Concatenate LOAD PrimaryKey, A, B, DateTimeField FROM DestFile.QVD
WHERE NOT exists(PrimaryKey);
STORE Table1 INTO DestFile.QVD;
I don't have PrimaryKey in my table
how to get $(LastExecTime)?
I faced the same issue ..we cant do incremental load without Date and Primary ID We shud have atleast one
if primary ID is not there try with Date.
If you want to do oly insert WHERE NOT exists(PrimaryKey) not needed
remove that from script and try t
Thanks
How to get the last updated time $(LastExecTime)?
Contact Database Team and tel them to add the Date Field