Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have loaded data into my qlikview and i have above 70 mio rows. This takes quite long time to reload everytime, and to develop in, because i need to save all the time.
What is the best practice to do?
Is it A:
Data.qvw and store this into QVD.
QVDLoad.qvw -> Load data from QVDs and Design here?
Or is it B:
Data.qvw and store this into QVD
QVDLoad.qvw -> Load Data and make the nessecary scriptning
Design.qvw -> Binary load from QVDload.qvw and design in here.
Or what?
OK.
Load the 60 mio records since today into qvds (only one time), and from tomorrow into new qvd (every day) ... this is incremental load
The app.qvw with chart load qvd very, very fast.
Well, the data changes everyday, so this is also not possible, and is always only showing todays data.
If you need retrieve 60 MIO records eveyr time (current status), you must wait.
But if you needn't retrieve 60 MIO every time, you can retrieve facts tables at 06:00am in a qvw and the other configuation tables (like Language-Texts) or other secondary tables (customer or items tables) in a second qvw at 07:00am.
Finally you'll need a third qvw with the insight charts that reloads from qvd at 08:00.
Other possibility is partial reload, execute parts of the script conditionally:
IF ispartialreload() THEN
........ here partial reload instructions
ENDIF
IF not ispartialreload() THEN
........ here complete reload instructions
ENDIF
... here partial & complete reload instructions
The LOAD must be preceded by ADD or REPLACE, please read the help file.
Thanks for the idea! i will keep that i mind when having incremental load data.