Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
please explain the mapping and incremental load.
reddy
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