Question
DKB
DKB
ES
DKB
Posted: Mar 8, 2021
Last activity: Mar 10, 2021
Last activity: 10 Mar 2021 15:37 EST
Closed
Solved
Purpose of pr_data_decision_df_part table
Hi all
We have the requirement for creating indexes for this table in the project for better performance. during the evaluation of the task, two questions rose about this table:
1) whats is its role in the processing on Pega Marketing? what is it does?
2) which are the risks of changing it?
Somebody could help me answer this questions?
thanks in advance
Rodrigo
***Edited by Moderator Marissa to update Platform Capability tags****
To see attachments, please log in.
Accepted Solution
Posted: 4 years ago
Updated: 4 years ago
Updated: 10 Mar 2021 15:37 EST
DCS
DCS
GB
Posted: 4 years ago
DKB
DKB
ES
@Rodrigo Leme dos Santos
Table pr_data_decision_df_part is used to manage Kafka consumer offsets within PEGA. There is a OOTB rule (consumer Of Kafka data) to maintain their offsets in the pxrecordsprocessed column. When Kafka message is processed, pega maintains offset in this table.
If your marketing application designed to use Kafka heavily, creating index (for the columns pxworkId, pxvalues) would improve the performance.
Thanks,
Nanjundan Chinnasamy | PEGA Lead Decisioning Architect