Automatically map load tables to a different source schema

Modified on Thu, 14 Apr 2016 at 03:12 PM

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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article