When you use an input parameter as the sort condition, you can provide one or more fields as the default parameter value. You can override the default value in the task. For each field you include in the default value, specify the object and field to sort by. If your organization supports multi-schema selection, you must also specify the schema. List sort fields as a comma-separated list in the following format:

"<schema1>"."<object1>"."<field1>", "<schema2>"."<object2>"."<field2>"

For example, to sort by the EMP_ID field in the Employees table, enter the following string:

"Employees"."EMP_ID"

If the connector supports nested levels, include the levels with the schema name, separated by a forward slash (/).

For example, to sort by the emp_id field in the EMPLOYEE_SCR01 table in a PostgreSQL database, you might enter the following string:

 "cloud/TABLE"."EMPLOYEE_SRC01"."emp_id"

Data Integration

ignores fields in the following situations:

When fields are not formatted correctly.
When the object and fields listed in the default parameter value don't match the source object.