Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
zahidrahim_ocp
Contributor

Advice required on complex oracle queries

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

1 Reply

Re: Advice required on complex oracle queries

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

Life is so rich, and we need to respect to the life !!!
Community Browser