Re: Incremental reload - Page 7 - Qlik Community

Report Inappropriate Content · ‎2010-04-21

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...?

vikasmahajan · ‎2014-02-05

Thanks for Sharing

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2014-02-05

Can you tell me please what UPPER(incremental_build) in your script.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2014-02-05

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