Support Article

Query on execution of dynamic segment

SA-28874

Summary



User wishes to know,when a dynamic segment executes within the campaign itself, where will be the data of the dynamic segment stored.
They need to trace back which records that are being targeted.


Error Messages



Not Applicable


Steps to Reproduce



Not Applicable


Root Cause



Not Applicable

Resolution



When a campaign executes, a dynamic table gets created in CMD schema and throughout the course of campaign execution, data gets written to that table. When the campaign execution gets completed, the table automatically gets dropped.
 
The data of all dynamic segments of all campaigns get written to the CAMP_COMM_OUT_DET table. To check data for the necessary campaign, the following SQL can be run in the database:
 
SQL> select * from CAMP_COMM_OUT_DET where camp_id=<campaign ID>;
 
The data written into the CAMP_COMM_OUT_DET table with regard to the dynamic segment may vary from the actual records that were being targeted when a campaign gets executed due to data field selection in the extract template for that campaign.

 

Published October 6, 2016 - Updated October 18, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.