Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello dears.
i implemented Incremental Load (Insert ,Update ,Delete)
i have a problem .
for the first time , i created qvd File. (i don't problem)
let vQVDExistsFile=isnull(QvdCreateTime('$(vSourceQvdFile)SaleQVD.qvd'));
if vQVDExistsFile=-1 then
Sale:
LOAD OrderId,
ProductId,
CustomerId,
Amount,
Date_Updated,
Num(Date_Updated) as NumDate
FROM
$(vSourceData)Sale.xlsx
(ooxml, embedded labels, table is Sheet1);
Store Sale into $(vSourceQvdFile)SaleQVD.qvd(qvd);
END IF
I found that change records for the second time
But i Can not Append into SaleQVD.qvd
All New Records (Update,Delete) Override into SaleQVD,Not Append
no , i want Implemented Incremental Load on fact Tables With millions Record.
i want Test And Applied in Fact Table