Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a QlikView application which loads the data from a
oracle database...
SELECT * FROM DB."DATE_DIMENSION";
Is there a way to do an incremental update of the data (only reload new data)
without loading the entire data of the db.
How is it possible...?
Thanks for Sharing
Vikas
Can you tell me please what UPPER(incremental_build) in your script.
Vikas
Hi , If you want Implement the Incremental loading the table must have below characteristics depends on your Incremental load type:
Only INSERT or NEW --> DATE FIELD (This must be tells us weather row is new or not w.r,t previous load)
INSERT & UPDATE --> DATE FIELD & PRIMARY KEY
INSERT, UPDATE & DELETE --> DATE FIELD & PRIMARY KEY