A parameter file is a list of user-defined parameters and their associated values. To perform a delta extraction, you can specify the update mode in a parameter file so that you do not need to edit the mapping every time you want to change the update mode.
To use a parameter file, perform the following steps:
Create a parameter file in the following directory:
In the parameter file, enter a parameter name and specify the parameter value that you want to use.
The parameter name must start with
$$
and cannot contain space characters.
You can use one of the following parameter values based on the update mode that you want to use:
0
. Use for Full.
1
. Use for Delta initialization without transfer.
2
. Use for Delta initialization with transfer.
3
. Use for Delta update.
4
. Use for Delta repeat.
Use the following format to specify the parameter name and parameter value:
$$<parameter_name>=<parameter_value>
Do not use space characters while specifying the parameter name and parameter value.
For example, enter:
$$deltaparameter=0
Save the parameter file.
Open the SAP table reader mapping that you want to use for delta extraction.
Select
Parameter
from the
Update Mode
list.
In the
Parameter Name for Update Mode
field, enter the parameter name that you defined in the parameter file.
Create a mapping task based on the SAP table reader mapping.
In the
Schedule
page of the mapping task, enter the parameter file name under the
Advanced Options
section.
Run the mapping task.
To change the update mode, update the parameter value in the parameter file, and run the mapping task again. For example, the first time you run a mapping task, you can specify the parameter value as
2
to use delta initialization with transfer. After the initial extraction is done, you might want to change the parameter value to
3
to capture only the changed data in the next mapping task run. Instead of updating the parameter value in the mapping every time, you can update the parameter value in the parameter file and run the mapping task again.
ASK INFAPreview
