Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Durgarao Jeeri (DurgaraoJeeri)
Coforge DPA UK Ltd.
Durgarao Jeeri
Coforge DPA UK Ltd.
IN
DurgaraoJeeri Member since 2016 41 posts
Coforge DPA UK Ltd.
Posted: Jul 16, 2017
Last activity: Oct 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.

To see attachments, please log in.
Decision Management
Data Integration

Accepted Solution

Posted: 7 years ago
Posted: 17 Jul 2017 11:15 EDT
Susan Liu (SusanLiu_GCS)
PEGA
Senior Principal Engineer, Technical Support, Runtime Engine
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

 

To see attachments, please log in.
Posted: 7 years ago
Posted: 28 Jul 2017 9:32 EDT
Durgarao Jeeri (DurgaraoJeeri)
Coforge DPA UK Ltd.
Durgarao Jeeri
Coforge DPA UK Ltd.
IN

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.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice