topic Re: Incremental load and apply map in QlikView

Incremental load and apply map

Wed, 05 Feb 2014 06:54:39 GMT

hi can any body explain i want to apply incremental load to the tables where applymap is used then how to make a script.

regards

Mahesh Thalluri

Re: Incremental load and apply map

Anonymous — Sat, 08 Feb 2014 16:10:16 GMT

have a look at this : http://www.packtpub.com/qlikview-11-developers/book

Re: Incremental load and apply map

stevedark — Sun, 09 Feb 2014 10:35:22 GMT

These two posts may help:

http://www.quickintelligence.co.uk/qlikview-incremental-load/

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

You will need to be more specific about your source data and what you are trying to achieve for me to give a more detailed answer.

Steve

Re: Incremental load and apply map

Jason_Michaelides — Sun, 09 Feb 2014 10:56:48 GMT

Can you be more specific?

Re: Incremental load and apply map

Sun, 09 Feb 2014 13:33:55 GMT

Mahesh,

Take care, to use ApplyMap, you have done a Mapping load before : it will create a TEMP table with two fields : key, value. This table is used for lookup purposes and therefore replace a key with a value, for example a Customer with a price discount in%, a product id with a product desc, a product id with a category id etc. it is like a join but much simpler. It is why there are only two fields.

This table is temporary: you do not need to delete it at the end of the script. It does not belong to your model.

You will need to reload completly this table (it is not a big one: 2 fields only, few lines compared to the fact table) for any load.

If you need to apply this lookup to an incremental load, I think you will need to do it into a temp table and afterwards to concatenate with your target table (concatenate ... resident load)

Fabrice

Re: Incremental load and apply map

Mon, 10 Feb 2014 08:39:48 GMT

Supppose i have used applymap to one source table .suppose any new data is inserted to the table used by applymap.

then we want the data to table in that scenariou.

regards

Mahesh t

Re: Incremental load and apply map

stevedark — Mon, 10 Feb 2014 09:02:37 GMT

Do you mean that you would want to refresh the old rows with the new

ApplyMap data?

If so, it depends on how frequently the data in the ApplyMap table changes.

If it is often changed then you may be better off applying the map after

the increment. Be aware of the impact to optimised loads though.

If it changes infrequently you may choose to do something in SQL to flag

the row as changed when the mapped data changes - using a JOIN and a last

updated date on the table.

Hope that helps.

Steve