Binary load, Section Access reduction method

coleturegroup — Fri, 17 Jun 2022 17:47:46 GMT

Question, I have a very large data transform we need to repurpose across multiple regions. Each region shares a slice of the contents from the transform data model. My question is can I utilize binary load to only load each regions data model to save space.

For example: the transform data model is 100 GiG. Binary load region 1, Binary load region 2, Binary load region 3,....

Each region might only consist of 10 GIG of data resulting in each regions app smaller then the transform app model in size.

Can this be done and how might that be executed?

Re: Binary load, Section Access reduction method

rubenmarin — Sun, 19 Jun 2022 07:37:54 GMT

Hi, only one binary is allowed by document, you can do a binary load of a document with allthe data and then reduce it doing some inner joins.

I think the ost common scenario to solve this is having qvds, you can have a qvd for each Region-Table, and the document of each region only load the data from the qvds of it's region.

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/work-with-QVD-files.htm

topic Re: Binary load, Section Access reduction method in App Development

Binary load, Section Access reduction method

Re: Binary load, Section Access reduction method