Smitha M (SmithaM0138)

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

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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.