topic Re: Incremental Reload - without using where condition in QlikView

Incremental Reload - without using where condition

Thu, 24 Apr 2014 05:16:57 GMT

Hi!

I need to extract massive volume of data from an database using an incremental reload. This table is not indexed and daily i need to load last two day's data checking the update date field.

If i apply where condition to check the update date field, its checking the entire database and giving me the last two day's data. Is there a way to extract only last two day's of data without checking the entire database.

Please help on this..

Thanks in advance!

Re: Incremental Reload - without using where condition

its_anandrjs — Thu, 24 Apr 2014 05:26:43 GMT

1. Store your update date in the variable like

Let vUpdateDate = Updatedfieldname

2. Then check this updated date in table like

Load * from Location Where Updatedfieldname > $(vUpdateDate);

Re: Incremental Reload - without using where condition

Thu, 24 Apr 2014 06:16:01 GMT

Hi! Anand,

Thanks for the reply. I am doing the same way (Using where condition).

My question is, if i apply where condition it will search the entire database and check whether the condition is satisfied or not and then will extract the latest data. This process will take considerable time.

Is there a way to do the incremental reload without checking the entire database ?

Thanks in advance !

Re: Incremental Reload - without using where condition

ashfaq_haseeb — Thu, 24 Apr 2014 06:16:36 GMT

Hi.

Incremental reload is Performed based on Date field and a primary key.

I don't think you can perform incremental reload without where condition.

Hope it helps

Regards

ASHFAQ

Re: Incremental Reload - without using where condition

its_anandrjs — Thu, 24 Apr 2014 06:21:24 GMT

In place or the date use primary keys and based on primary keys load the latest data. If primary key is not available then use composite keys.