Setting Default Values for a Field
You can configure a default value for a field in the Data Transformation section. Default values are primarily used to assign a predefined value when an input field in the file is empty or missing. The default value configuration is done at the Sequence 0 index in the Field Transformation section. For date-type fields, default values can be set using predefined constants like:
-
:BUS_DATE– Business Date -
:SYSDATE– System Date -
:STD_DATE– Standard Locale Date -
:BUS_DTTM– Business Date and Time -
:SYS_DTTM– System Date and Time -
:STD_DTTM– Standard Locale Date and Time
