mapping and incremental load

Fri, 03 Jun 2011 05:32:23 GMT

please explain the mapping and incremental load.

reddy

Re: mapping and incremental load

Fri, 03 Jun 2011 05:41:38 GMT

Hi,

I would like to give brief overview of mapping load & incremental load below:-

MAPPING LOAD:

Basically mapping load is used to map any code to some description. Mapping load works on key & value pair. For example if you have definition of some code in you master table. In transaction table you just have code only, so to get the description from master table to transaction table either we can use join or the better way is to use mapping load.

Syntax:-

MapDesc:

MAPPING LOAD

Code,

Desc

FROM

Source.qvd (qvd);

//Call it in transaction table

ApplyMap('MapDesc', <KeyField>, <Default value for non matching codes, it's optional>)

INCREMENTAL LOAD:-

Incremental load is for loading incremental data. For more explantion on it please see attached powerpoint file.

Rgds,

Dhananjay

topic mapping and incremental load in QlikView

mapping and incremental load

Re: mapping and incremental load