This content has been marked as final.
Show 2 replies
-
Re: data base refreshing ?
omar bensalem May 31, 2017 8:23 AM (in response to Kafil EL KHADIR)suppose you have a table :
table:
load *
from source;
//you should store it in a QVD
store table in ...path.qvd(qvd);
once you've done this the first time; comment this and do as follow:
// call the data within your qvd:
table:
load * from yourQvd;
concatenate
load * from source; //this now contains new data after refresh
store table in path.qvd(qvd) //the same qvd file
with that, everytime you do a reload; it will call the qvd (the ancient stored data before refresh) and add to it the new data of the table after the refresh, then store all of it in the same qvd to call again and again.
this is incremental load using qvds; you should take a look at it;
hope this helps
-
Re: data base refreshing ?
Kafil EL KHADIR May 31, 2017 8:38 AM (in response to Kafil EL KHADIR)Hi,
Thanks i will try it come back to you if ther is a problem,