Date format for conversion to text in unpivot transformations

This profile determines the date format for use by an unpivot transformation when converting DATE datatypes to VARCHAR2.

1. Log in. See Set profiles to determine system behavior.
2. In the Profile field, enter DMW_XFM_UNPIVOT_DATE_FORMAT.
3. Click Find.
4. In the Site column, do one of the following:
   • Leave blank. The system uses the default date format in the database.
   • Enter a valid Oracle date format, for example, DD-MM-YYYY for 22-01-2018 or DD/MON/YYYY for 22/JAN/2018.
5. In the File menu, select Save and Proceed.