How to store dynamically changing data

[dseelam]

Hello All,

Is it possible to store history of  dynamically changing data every day in the form of single QVD

if the above is not possible how to store dynamically changing data in the form of different QVD's one for each day and store in single folder ??

Is it make sense to use incremental loading for dynamic data ?

Thanks in advance

[maxgro]

not sure if I understand

read a qvd

add some data with a date (today) field

store in the same qvd

[dseelam]

max,

I am loading data from oracle every day which is dynamically changing, How can I search history in this case

so I want to store every day load as a single QVD with date as a QVD name

is it possible ??

[maxgro]

Z:

sql select * from oracletable;

let d=date(today(), 'YYYYMMDD');

store Z into Z_$(d).qvd (qvd);