Question

3
Replies
1169
Views
 Durgarao Jeeri (DurgaraoJeeri)
Incessant Technologies
Software Engineer
Incessant Technologies
GB
DurgaraoJeeri Member since 2016 39 posts
Incessant Technologies
Posted: July 16, 2017
Last activity: October 16, 2018
Posted: 16 Jul 2017 13:36 EDT
Last activity: 16 Oct 2018 12:03 EDT
Closed
Solved

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.

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.

Accepted Solution

Posted: 4 years ago
Posted: 17 Jul 2017 11:15 EDT
Susan Liu (SusanLiu_GCS)
PEGA
Principal Software Solutions Engineer
Pegasystems Inc.
US

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 table MKTSCHEMA.MKTSEGMySeg01 in database ExternalMKTData.


MKTSEGMySeg01 is the new table created in ExternalMKTdata. 


See my attached snapshots.


Thanks,


Susan


 
Posted: 4 years ago
Posted: 28 Jul 2017 9:32 EDT
Durgarao Jeeri (DurgaraoJeeri)
Incessant Technologies
Software Engineer
Incessant Technologies
GB

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.
Posted: 3 years ago
Posted: 15 Dec 2017 9:09 EST
Gongping LIU (GongpingL)
Accenture Pte Ltd

Accenture Pte Ltd
SG

Hi there,


Is there any way we can save these automatically generated batch files in a designated DB folder?