topic Re: Data refresh instantly in QlikView

Data refresh instantly

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We have scenario where data refresh is done instantly means as soon as new record enters into OLTP/transactional database , it goes to datawarehouse, in this case how should I implement incremental load

Re: Data refresh instantly

squeakie_pig — Mon, 08 Aug 2016 16:01:33 GMT

What about continuous reload?

Where is the continuous reload button on QMC?

Re: Data refresh instantly

Mon, 08 Aug 2016 17:08:12 GMT

how it will load only newly inserted record?

Re: Data refresh instantly

Tue, 09 Aug 2016 01:33:58 GMT

Hi ,

I have date stored as two columns in database , both are numeric

example Date- 115321 , Time - 10515

There is no daily refresh in ODS , as soon as record in into database it goes to ODS and it should reflect in report/dashboard after doing refresh, in this scenario how can I implement incremental load

Secondly how can I interpret time stamp 10515 in min,hours and second

Re: Data refresh instantly

avinashelite — Tue, 09 Aug 2016 06:03:32 GMT

check this

Incremental load in Qlikview

Incremental Load Scenarios.pdf

Incremental Load.docx

Incremental Load Script

Re: Data refresh instantly

Tue, 09 Aug 2016 06:25:27 GMT

Hi Vibhu,

Using QMC We can do:

See below screenshot:

Thanks

Nandu

Re: Data refresh instantly

vikasmahajan — Tue, 09 Aug 2016 07:08:15 GMT

additional you can explore this Direct Discovery

Vikas