1 Reply Latest reply: Jun 3, 2011 1:41 AM by Dhananjay Mishra RSS

    mapping and incremental load

      please explain the mapping and incremental load.

       

      reddy

        • Re: mapping and incremental load

          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