I have 2gb of data file which is in csv.i have 2GB RAM.
I am not able to load file. is there any way we can compress data without increasing the system configuration.
are you able to split data through several smaller QVD ?
for example, loading 1 year at a time, storing each year in a dedicated QVD
LOAD * FROM mycsv WHERE year=vYear
STORE mytable INTO mytable & vYear.QVD
@mall1m:i dont want to break the into qvd's
@Koushik: i aam not able to load csv then how can i able to create qvd.
Please ssuggest some other ways .
I think the way could be devide the data into QVD's. Say for example for one year or on another basis.
And then again create a QVD whith combined data from all small QVD's and then try to load it.
Not possible the reason is while loading data QlikView loads data in RAM, and if you have less RAM then there is no chance.
I dont know if it can be done by increasing the virtual memory.
Just try that.
Go to Control Panel -> System -> Advanced System Settings -> Advanced tab -> Performance -> settings -> Advanced tab -> Virtual memory.
This is for Windows 7.