topic Re: Modified date and last execution time in QlikView

Modified date and last execution time

Thu, 17 Apr 2014 04:31:39 GMT

i have one doubt how we get modification time and last execution time in implementing incremental load.

modified date will get after trasformations or before let me know how to get last execution time

Re: Modified date and last execution time

its_anandrjs — Thu, 17 Apr 2014 04:35:24 GMT

Use last reload date and time like Reloadtime() function and use this date for last execution time.

Let vReloadtime = Reloadtime();

Re: Modified date and last execution time

Thu, 17 Apr 2014 04:37:02 GMT

when will be modification time will greater than last execution time

Re: Modified date and last execution time

its_anandrjs — Thu, 17 Apr 2014 04:39:27 GMT

Modification time you get from database like where updation dones and then you check that last updation date with last reload time when you reload the application.

Re: Modified date and last execution time

Thu, 17 Apr 2014 04:47:12 GMT

Thank u.

Ok. But it will not work to all SAP tables because some tables dont have date and time field.

I got problem in some of the SAP tables like

MSEG,

JEST

KONV

and production related tables.

So, I used incremental load.

Thanks and Regards

Amol Khochare

Re: Modified date and last execution time

its_anandrjs — Thu, 17 Apr 2014 04:50:25 GMT

Yes because in SAP if table is cluster table then you are not able to get last modified data easily because it is maintain in different table and it is difficult to give incremental load for the cluster table because it is a combination of the 2 or more tables.

Re: Modified date and last execution time

Thu, 17 Apr 2014 04:56:11 GMT

Yes, correct.

If I use deferent fields instead of date and time like document no, item and combi of both etc. whichever is suitable. Will it be work or right way to define incremental load?

Regards

Amol Khochare

Re: Modified date and last execution time

its_anandrjs — Thu, 17 Apr 2014 05:18:02 GMT

Yes you are right.

Re: Modified date and last execution time

VamsiBhagavathula1 — Tue, 02 Apr 2024 12:24:47 GMT

@its_anandrjs if we use last execution time as with Reloadtime() , That means we need atleast one sucessfull reload for the app otherwise data load gets failed.