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 Susan,
Thank you very much,it helped me in finding the table details. I could able to find it and explore more through this.
I got one more doubt from this. I could able to find a new report definition for each time campaign being created(means refreshed when campaign run starts). The report definition is in different format unlike you have mentioned in your case, it is "Data-BatchOutPR1235" attached the screenshot too. How can the name pattern decided, can't we control it? and how can we control the mapping of this class to a table?
Thanks in advance.
Regards,
Durgarao J.
Hi there,
Is there any way we can save these automatically generated batch files in a designated DB folder?
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-SEGMySeg01is mapped to tableMKTSCHEMA.MKTSEGMySeg01in databaseExternalMKTData.MKTSEGMySeg01is the new table created in ExternalMKTdata.See my attached snapshots.
Thanks,
Susan