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

 Smitha M (SmithaM0138)
Wipro

Wipro
IN
SmithaM0138 Member since 2019 1 post
Wipro
Posted: Jun 9, 2019
Last activity: Jun 10, 2019
Posted: 9 Jun 2019 0:32 EDT
Last activity: 10 Jun 2019 0:39 EDT
Closed

INteraction History Tables Usage

I am new to Pega, so apologies if mine is a basic question !

We are setting up Pega in our environment and we understand the 9 interaction history tables(1 fact and multiple dimension tables in a star schema) are used for decisioning.

I translated it as, " when I login to my web portal and browse something, these 10 Pega tables are quickly queried to give me recommendations based on my browsing"

I would like to understand if that is all the case. The IH tables are simple Oracle tables and the queries would take longer and longer if my customer base increases.

Also, I would like to use the IH tables for my analytics too but do not want to impact performance to my customers.

Are there other tables that can be used for analysis - that are more aggregated/summarized?

How does Pega manage querying the database for each logged in customer (Surely, it is not a full table scan of the IH tables !!! )

To see attachments, please log in.
Conversational Channels
Decision Management
Data Integration

Posted: 5 years ago
Posted: 9 Jun 2019 19:21 EDT
Arvind Malav (malaa) Technical Manager
Pegasystems Inc.
IN

 

Hi Smitha,

Your understanding is not correct here.

These IH tables are updated when an interaction happens between user of Product with customer.

For example, telecom company interacting with its customer.

To understand Decisioning, kindly go through 

1)- Pega academy course for Decisioning here:

https://academy.pega.com/certification-paths/decisioning-consultant

2 PDN here:

https://community.pega.com/sites/default/files/help_v72/procomhelpmain.htm#dsm/concepts/DSM-overview-con.htm%3FTocPath%3DDecision%2520Strategy%2520Manager%7C_____0

 

To see attachments, please log in.
Posted: 5 years ago
Posted: 10 Jun 2019 0:39 EDT
Pawan Narain Singh (pawann)
Swedbank AB

Swedbank AB
SE

Hello Smitha,

 

You can review your PegaAlert logs to identify if there are any issues while interacting with the IH.

You need to look for the following alerts in order to locate them:

Show More

Hello Smitha,

 

You can review your PegaAlert logs to identify if there are any issues while interacting with the IH.

You need to look for the following alerts in order to locate them:

PEGA0058 - Interaction History read time above threshold DSM IH Read Time
PEGA0059 - Interaction History write time above threshold DSM IH Write Time
PEGA0060 - Number of Interaction History rows read above threshold DSM IH Read Row
PEGA0061 - Number of Interaction History rows written above threshold DSM IH Write Row

Let us know if this helps!

 

Thank you,
Pawan


Show Less
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