What is the difference between Optimisation wizard and Column Population Jobs?
What is the difference between Optimisation wizard and Column Population Jobs?When optimisation wizard exposes the property then why do we need column population jobs
Accepted Solution
Updated: 12 Jun 2024 16:10 EDT
Rulesstack Private Limited
IN
Hi @TanyaS58 ,
The difference between the Optimization Wizard and Column Population Jobs in Pega is as follows:
Optimization Wizard: Used to expose properties by creating new columns in the database table, allowing for efficient querying and reporting.
Column Population Jobs : Used to populate the new columns with existing data from the BLOB, ensuring the new columns contain accurate data for use.
Why both are needed : The Optimization Wizard creates the new columns, and Column Population Jobs fill these columns with the existing data, making both steps necessary for effective property optimization.
Thanks,
Mohd Qizer Uddin
Maantic Inc
IN
When you run the optimization wizard, Pega actually runs a column population job backend. In SQL terms its known as column population job but in Pega its call property optimization.
Accepted Solution
Updated: 12 Jun 2024 16:10 EDT
Rulesstack Private Limited
IN
Hi @TanyaS58 ,
The difference between the Optimization Wizard and Column Population Jobs in Pega is as follows:
Optimization Wizard: Used to expose properties by creating new columns in the database table, allowing for efficient querying and reporting.
Column Population Jobs : Used to populate the new columns with existing data from the BLOB, ensuring the new columns contain accurate data for use.
Why both are needed : The Optimization Wizard creates the new columns, and Column Population Jobs fill these columns with the existing data, making both steps necessary for effective property optimization.
Thanks,
Mohd Qizer Uddin