Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rodrigo Leme Santos (Rodrigo Leme dos Santos)
Accenture Spain
Application Development Associate
Accenture Spain
ES
Rodrigo Leme dos Santos Member since 2018 4 posts
Accenture Spain
Posted: Mar 8, 2021
Last activity: Mar 10, 2021
Posted: 8 Mar 2021 14:09 EST
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.
Pega Platform 8.4.3
Data Integration
Decision Management
Performance

Accepted Solution

Posted: 4 years ago
Updated: 4 years ago
Posted: 9 Mar 2021 2:31 EST
Updated: 10 Mar 2021 15:37 EST
Nanjundan Chinnasamy (Nanjundan Chinnasamy)
DCS
PEGA Lead Decisioning Architect
DCS
GB

@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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice