Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I have problem with qvd file. I have a script with two params. When I set this params changeble value and reload scripr - qvd file becomes bigger. But even when I set this params as constant value - qvd still grows and rows in it becomes more and more. Reload by reload. Tables in sourse is slill the same, with same data.
I have no idea why it is happens.
Example of script:
Load_T_tmp:
load
TIMEPART_ID,
ADDRESS_ID,
CLIENT_ID,
CITY;
sql
SELECT (some fields with "case")FROM some_view($(vStart),$(vEnd));
Join(Load_T_tmp)
LOAD
GOODS_ID,
LINK_GOODS_ID;
SQl
SELECT (some fields with "case") FROM some_table;
ResTab:
load
TIMEPART_ID,
ADDRESS_ID,
CLIENT_ID,
CITY,GOODS_ID,
LINK_GOODS_ID;Resident Load_T_tmp;
DROP Table Load_T_tmp;
Period_List:
LOAD Distinct
TIMEPART_ID as [Period_list]
Resident ResTab;
ResTab:
load
TIMEPART_ID,
ADDRESS_ID,
CLIENT_ID,
CITY,GOODS_ID,
LINK_GOODS_ID;
FROM $(vMyPath)SaveResTab.qvd (qvd)
WHERE NOT EXISTS (Period_list,TIMEPART_ID);
store ResTab into $(vMyPath)SaveResTab.qvd;
drop Table ResTab;
drop Table Period_List;
Could be the lineage info:
Expansion of QVD file size during iterated process
Gysbert, thank you for your advice. I saw this topics and tried to use knowledge about "AllowDataLineage", but got no result