Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have one qvd.that qvd contains 3 months of data.(ex:mainqvd contains apr,may,jun upto 24thdate 2015),i am getting the daily data from excel.
ex:
prev_usage:
Load
Dir,
date,
space
from
mainqvd.qvd(qvd) this qvd contains total data.
concatenate
curr_usage:
Load
Dir,
date,
space
from
Today.xlsx daily excel.
i am concatenating the daily curr_usage: data to prev_usage: now i dnt have any issue.but in future we will get more months of data.that will be added to mainqvd.qvd(qvd) .
that time it will take more time to load mainqvd.qvd(qvd) to concatenate the curr_usage: data.
Now My Requirement is
first i want to split that mainqvd.qvd(qvd) into monthly wise qvd's like apr.qvd,may.qvd,june.qvd.
but thing is june.qvd contains the data upto 24/06/2015 .now when 25/06/2015 data comes i want to add that 25/06/2015 data to june.qvd like this upto 30/06/2015
when 01/07/2015 data comes on that day i want create july.qvd and store the data into july.qvd,when 2/07/2015 data comes that data add to july.qvd like this upto 31/07/2015.when 1/08/2015 comes i want to create august.qvd
how to achive this?
help me on this...
regards,
kd
Any Idea?
Hi,
I believe if you use incremental load and then later you split data in monthly qvds, load time would come down considerably.
Regards,
Navdeep
Did you get the solution for it? if yes could you please share the same with us, I am also having the same problem. @d_koti24