SST Enhancement

Enhance the mapping of campaign data sources within the Pixel Listener and Data Integration (DI) framework.

To enhance the SST in Pixel Listener, follow the steps below:

1. Insert the campaign data source details in the DMPCampaignDataSourceMapping table. Use the following queries in sequence.

   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES (<DataSourceId>, <AttributeId>, 0, 'UPDATE', '{"input_col": "properties__customer_id", "alternate_keys":["properties__userId","otherIds__customerId", "otherIds__customer_id"]}');
   commit;
   
   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES (<DataSourceID>, <AttributeId>, 0, 'UPDATE', '{"input_col": "otherIds__email"}');
   
   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES (<DataSourceID>, <AttributeId>, 0, 'UPDATE', '{"input_col": "otherIds__phone"}');
   
   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES (<DataSourceID>, <AttributeId>, 0, 'UPDATE', '{"input_col": "properties__name"}');
   commit;
   

2. Similarly, update enhancements for DI framework using the following queries in sequence.

   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES ((<DataSourceId>, <AttributeId>, 0, 'UPDATE', '{"input_col": "properties__FIRST_NAME"}');
   
   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES ((<DataSourceId>, <AttributeId>, 0, 'UPDATE', '{"input_col": "properties__LAST_NAME"}');
   
   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES ((<DataSourceId>, <AttributeId>, 0, 'UPDATE', '{"input_col": "hashed_email"}');
   
   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES ((<DataSourceId>, <AttributeId>, 0, 'UPDATE', '{"input_col": "hashed_mobile"}');
   
   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES ((<DataSourceId>, <AttributeId>, 0, 'UPDATE', '{"input_col": "properties__CITY"}');
   
   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES ((<DataSourceId>, <AttributeId>, 0, 'UPDATE', '{"input_col": "properties__STATE"}');
   
   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES ((<DataSourceId>, <AttributeId>, 0, 'UPDATE', '{"input_col": "properties__COUNTRY"}');
   
   INSERT INTO DMPCampaignDataSourceMapping (DMPCampaignDataSourceId, DMPCampaignDataDictionaryId, IsMandatory, ProfileUpdateFunction, Metadata) 
   VALUES ((<DataSourceId>, <AttributeId>, 0, 'UPDATE', '{"input_col": "properties__customerId"}');
   
   commit;
   
   #<DataSourceId> is from DMPCampaignDataSource Table and <AttributeId> is from DMPCampaignDataDictionary.