How Delete work's in Insert, Update & Delete method of Incremental Load?

[amars]

Hi all,

In Insert, Update & Delete method of Incremental load, I couldn't understand how Delete work's. Please if any one could tell me that? As per the reference manual

Script example:

Let ThisExecTime = Now();

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE WHERE ModificationTime >= #$(LastExecTime)#

AND ModificationTime < #$(ThisExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT EXISTS(PrimaryKey);

Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

If ScriptErrorCount = 0 then

STORE QV_Table INTO File.QVD;

Let LastExecTime = ThisExecTime;

End If

But where it has code for Delete?

Thanks In advance.

[#2]

Hi Amar,

the inner Join method was used to remove the deleted records from the QVD file.

inner join will return only the common records in both the table.

[amars]

Hi Gopinathan,

Can u explain in brief, how the inner join will remove the deleted records.

Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

Thanks in advance.

[SanjeevR]

@amars Good Day, Did you ever get a solution to this query as I have the same issue because my inner join is not deleting the records.