Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear friends
I have requirment while loading for QVD i need to find product of 2 colums into amounter column. is the below load statement is correct, if not give me the solutions.
LOAD
MQTY,
PSTOCKVALUE,
COST_RATE,
COST_RATE * MQTY AS MSTOCKVALUE
FROM
[STOCK_DETAIL_DEL.QVD]
regards
Logu C
Logu,
yes, this is just fine, it will work. Keep in mind that it will slow down your load substantially, because the load won't be optimized (super-fast) anymore.