12.3.18 Parameters in Connector

Parameters are used when defining the EDD to ADI mapping. While mapping the ADI to an EDD, the fields or columns within the ADI must be mapped to the fields in the EDD. If there are no corresponding extracts in EDD, parameters can be used to identify the default values for certain ADI elements. Parameters can also be used while defining derived columns during mapping.

For example, if you want to use the Runtime MIS Date as the parameter, you must first convert it to date. The following is the expression:

To_char(to_date(#DIHDEV.MIS_DATE,’dd-MON-YYYY’),’MM’)

Note:

Runtime batch MIS date is in String format. You must convert it to a valid SQL date format.