1 Reply Latest reply: Sep 25, 2017 9:43 AM by Anil Babu RSS

    Advice required on complex oracle queries

    zahid Rahim

      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