Data Modeling

[dseelam]

Hello All,

This is a totally new project for me working on inventory DB, Help ?

I have 3 views in oracle one for Item master, Customers and BOM, Am pulling them and storing them in to separate qvd's one for each day to have track of history & implemented section access for all 3 tables it is successful

everything was fine but even though I implemented section access I feel like am pulling data every day in to separate QVD which means I am almost pulling every thing again, Is there a way that I can only derive changes (inserted updated and deleted records)? and store them in separate QVD for each day ? so that I can save lot of space along with time ??

Time for reloading data directly from Oracle

after implementing section access

when I compare number of lines for each day in direct reload and incremental load it does not make any sense

[Clever_Anjos]

I usually don´t use incremental load, but "sliced".

My qvd´s  usually are generated like this:

LET Dat=Date(today(),'YYYY-MM-DD');

t:

sql

select [fields] from mytable where date_field = '$(dat)';

Store t into [$(Path)\file_t_$(Dat).qvd](qvd);

[Clever_Anjos]

Section Access is not related to QVD files, but to QVW, ok?

[dseelam]

Sorry I miss worded, it is not section access incremental loading

[Clever_Anjos]

Ok, I think your could analyze a different approach like mine

[dseelam]

I am also using same logic to pull and save data for each day, but what I am asking is you are loading same data with changes every day in diff QVD's instead of that is there any way to store only changes from 2nd day

[hectorvega]

Maybe you could use this Sub-Routine for Incremental Load | Qlik Community

This will read only new and modified records

Regards