Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
have a look at this : http://www.packtpub.com/qlikview-11-developers/book
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
Can you be more specific?
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
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
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