Question

2
Replies
306
Views
SmithaM0138 Member since 2019 1 post
Wipro
Posted: 1 year ago
Last activity: 1 year 3 months ago
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 !!! )

Conversational Channels Decision Management Data Integration
Moderation Team has archived post
Share this page LinkedIn