Data refresh instantly

[#1]

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

[squeakie_pig]

What about continuous reload?

Where is the continuous reload button on QMC?

[#3]

how it will load only newly inserted record?

[#4]

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

[avinashelite]

check this

Incremental load in Qlikview

Incremental Load Scenarios.pdf

Incremental Load.docx

Incremental Load Script

[#6]

Hi Vibhu,

Using QMC We can do:

See below screenshot:

Thanks

Nandu

[vikasmahajan]

additional you can explore this Direct Discovery

Vikas