I am needed of best practice/advice on qlik development which i have to face for almost every analysis. I have already Oracle highly Complex queries which contain millions of record.
Now should i use the complex query as it is in Qlik. In full load once load data and avoid the rejoining/rewriting joins in Qlik then how to handel incremental data?
OR should i break the query in individual qvds (per table per qvd) and then handel all the joins complexity in Qlik by joining qvds, populating qvds with incremental data.
I would always go second option to break QVD's and then load and finally we need to use optimize load like Binary Load
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
