Posted: 16 Jul 2017 13:36 EDT Last activity: 16 Oct 2018 12:03 EDT
what is the database table name created when the Pega marketing segment's criteria is converted into data base query?
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?
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 table MKTSCHEMA.MKTSEGMySeg01 in database ExternalMKTData.
MKTSEGMySeg01 is the new table created in ExternalMKTdata.
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?