Best approach for Optimized QVD Load

Tue, 08 Apr 2014 06:11:11 GMT

Hello,

I need your help to make my QVD load optimized.

Current Scenario:
There are two tables, say A and B. *******Table A is of Greenplum DB while B is from ORACLE. ******

Data in A ---> more than a million. Data in B ---> Around 100.

Data from Table A is extracted and QVD_A.qvd is prepared. Similarly, QVD_B.qvd is from table B.

These QVDs are joined at the time of QVD load, as well as perform some calculations (transformations), making it non-optimized.

Desired Scenario:

Best approach to make QVD load optimized.

My Approach:

***Limitation: At the time of extraction, I can't apply joins, as creating DB link in Greenplum DB is not a plausible approach. DBAs don't allow that.***

So, I decided to extract them separately, making two different QVDs. Then, make a temporary table from these two QVDs by applying joins between them and apply all calculations at the same time.

Now, I will treat this temp table as my resident table. And final QVD load (without having to do any calculations and no joins) will take place from this table making it Optimized QVD load.

Is there a better approach for Optimized QVD load?
Thank you!

topic Best approach for Optimized QVD Load in QlikView

Best approach for Optimized QVD Load