You can create a parameter on your Development environment called SOURCE_SCHEMA


This parameter can be used on the Source tab of the Load table like: $PSOURCE_SCHEMA$




You can set the parameter value on your development environment to the required schema and you can create the same parameter on the Production with the production source schema name.


Example for Parameter setup on Development




Example for Parameter setup on Production:




With this setup, when you deploy into production, the source schema on the load table will point to the schema specified in the SOURCE_SCHEMA specified in the parameter on the production server.