Question
what is the database table name created when the Pega marketing segment's criteria is converted into data base query?
Hi,
I read somewhere that the segment's criteria is converted to data base query and a data base table is created and the customers satisfying the conditions are loaded into that table. What is the table name created for this and can we look into this table? is that data is temporary, I mean the data is persistent till the campaign run?
Thanks
Regards,
Durgarao J.
***Moderator Edit: Vidyaranjan | Updated Categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Hi Durgarao,
Based on my recent learning on Pega Marketing, when you successfully created a segment, a report definition was created accordingly.
For example, on my Pega Marketing system, I created a new segment, "MySeg01". A report definition, "MySeg01RD", under a new class, "PegaMKT-Data-Customer-SEGMySeg01", was created too. You can go to DesignerStudio -> Records -> Reports -> Report Definition to find out this new Report Definition.
Under Pages&Classes tab of the new Report Definition, "MCDB" page is pointing to the your data customer table. "PegaMKT-Data-Customer-SEGMySeg01" is the new class. Open this class and click on "Test connection", you will see the mapping below:
The newly created class
PegaMKT-Data-Customer-SEGMySeg01
is mapped to tableMKTSCHEMA.MKTSEGMySeg01
in databaseExternalMKTData
.MKTSEGMySeg01
is the new table created in ExternalMKTdata.See my attached snapshots.
Thanks,
Susan