to show updated records in incremental load

[#1]

hello

plz clarify my doubt on incremental load

i have a table with 3 records loaded on 25 aug 2013 i.e initial load and next day on 26th i have updated another 2 records i.e total 5 records.so my question is that i want only to show that 2 updated records which was inserted on 26th only instead of previous records. plz help in this issue.

[#2]

I'm assuming that your incremental load uses some variable to know what timestamp to load from. If you save the previous mas timestamp to a new variable that variable is then available within your code so that you can create some button with an action that will set that value as a filter.

[Clever_Anjos]

Please check your manual for Incremental Load, what you need is there at "Case3:InsertandUpdate(NoDelete) "

Basically you´ll need a primary key to you table, so you can load only the fresh new records

QV_Table:
SQL SELECT PrimaryKey, X, Y
FROM DB_TABLE
WHERE ModificationTime >= #$(LastExecTime)#;
Concatenate
LOAD PrimaryKey, X, Y
FROM File.QVD
WHERE NOT Exists(PrimaryKey);
STORE QV_Table INTO File.QVD;

[#4]

Hi Clever Anjos,

Can u please let me know how to get

ModificationTime >= #$(LastExecTime)#;

these fields.

[Clever_Anjos]

You have to check your table and find out if it has a field like this