Question

5
Replies
1523
Views
ZHANQ Member since 2007 5 posts
PEGA
Posted: 3 years ago
Last activity: 3 years 7 months ago
Closed
Solved

How to deploy property optimization result to production

In Dev, when we need to expose a column, we right click the property using property optimize tool to create new Database columns and populating the columns with values from blob, usually this is less than 5 minutes work.

Due to the production level setting, this option is not available in production. Seems the only way left is to run SQL in database to create the table columns(s), and run the command line column populate tool to populate the newly created column(s).

Due to the process overhead and production system accessibility, this approach is way more time consuming than the property optimization wizard.

Is it still advisable to directly run the property optimization wizard in production, or do we have any best practice how to deploy the property optimization result into production ?

Thanks

Tom

***Moderator Edit: Vidyaranjan | Updated Categories***

Data Integration
Moderation Team has archived post
Share this page LinkedIn