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.