Advice required on complex oracle queries

[zahidrahim_ocp]

Dear Experts,

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.

Regards,

Zahid Rahim

[Anil_Babu_Samineni]

I would always go second option to break QVD's and then load and finally we need to use optimize load like Binary Load