Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a Dataset like this below which gets stored into QVD.
INVOICE_NUM | INVOICE_LINE_NUM | DAY | FLAG | ROW_ADD_STP | ROW_UPDATE_STP |
1001 | 11 | MON | N | 9/20/2021 | 9/20/2021 |
1002 | 22 | MON | N | 9/20/2021 | 9/20/2021 |
Now the next day/daily load, the Incremental Reload should ONLY fetch the Updated Records from the Dataset and gets Concatenated/Appended (using Not Exists criteria to avoid duplicate) to the yesterday's QVD.
Suppose the next day, the Dataset looks like this below:
INVOICE_NUM | INVOICE_LINE_NUM | DAY | FLAG | ROW_ADD_STP | ROW_UPDATE_STP |
1001 | 11 | MON | Y | 9/20/2021 | 9/21/2021 |
1002 | 22 | MON | Y | 9/20/2021 | 9/21/2021 |
1003 | 33 | TUE | N | 9/21/2021 | 9/21/2021 |
1001 | 111 | TUE | N | 9/21/2021 | 9/21/2021 |
1002 | 222 | TUE | N | 9/21/2021 | 9/21/2021 |
Requirement:
Challenge (How to Delete the Past Records from QVD whose FLAG got changed from N to Y in Dataset):
INVOICE_NUM | INVOICE_LINE_NUM | DAY | FLAG | ROW_ADD_STP | ROW_UPDATE_STP |
1003 | 33 | TUE | N | 9/21/2021 | 9/21/2021 |
1001 | 111 | TUE | N | 9/21/2021 | 9/21/2021 |
1002 | 222 | TUE | N | 9/21/2021 | 9/21/2021 |
Please suggest ways to Delete the updated Records from the Past/Historical QVD.
Regards!
Inner join (your table name)
Sql select invoicenum,invoicelinenumber from table name:
Store table into your path\qvdname.qvd
I have similar issue like this. How can i delete updated past records after i load updated records in incremental load method?