Query on execution of dynamic segment
SummaryUser 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 MessagesNot Applicable
Steps to ReproduceNot Applicable
Root CauseNot Applicable
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