topic Re: Reduce Data during Binary Load in QlikView

Reduce Data during Binary Load

Anonymous — Wed, 19 Feb 2014 20:35:47 GMT

Hi,

I would like control data size during binary load(Ex specific department data during Binary load)

Ex: My computer is 4GB RAM and I have Qlikmart uncompressed size is 4.9GB and Compressed format it is close 1GB file.

When I load Binary load of that Qlikmart some times my system getting hang, I would like to See there is any process to control data during binary load (Not after/before load into application), I mean i want in run time.

Re: Reduce Data during Binary Load

Wed, 19 Feb 2014 20:42:12 GMT

Hi Jaswant,

no way during the bin load, as far as I know. Only workarounds like you still mentioned.

Re: Reduce Data during Binary Load

Clever_Anjos — Wed, 19 Feb 2014 20:46:58 GMT

Shortly you cant do that

Binary load is so fast because all data is load at one time without transformation or further checking

Re: Reduce Data during Binary Load

Wed, 19 Feb 2014 20:48:58 GMT

There is no way to control your data through binary load. You have to do optimize your script.

Re: Reduce Data during Binary Load

Anonymous — Wed, 19 Feb 2014 20:57:12 GMT

Thanks all, Then probably i need to break that Qlikmart into small qlikmarts.