Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Updating existing PK in the table

Avatar

Level 1

If there is a custom schema with composite PK. Is it recommended to change the composite PK and remove columns from previous PK and add new columns?

 

Will this change result in corruption of existing campaign workflows using the schema? Any other issues and if there is a recommendation on dealing with this type of change?

 

Thanks. 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @RajatPanwar ,

 

The change of a column in the Primary Composite key will not corrupt the columns not the data in the Schema.

 

In the downstream Campaigns, in any logic if you are using the Reconciliation Keys in Enrichment to Join or Using Update Data activity these keys should be changes accordingly as per the Unique Primary key combination, so that it won't be impacting the Campaigns.

 

Regards,

Pravallika.

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hi @RajatPanwar ,

 

The change of a column in the Primary Composite key will not corrupt the columns not the data in the Schema.

 

In the downstream Campaigns, in any logic if you are using the Reconciliation Keys in Enrichment to Join or Using Update Data activity these keys should be changes accordingly as per the Unique Primary key combination, so that it won't be impacting the Campaigns.

 

Regards,

Pravallika.

Avatar

Level 1

Thanks. if the new composite PK have records in the schema which are not unique based on the combination, will the schema/other screens in the console through an error and we need to clean up those rows and make it unique based on the new composite PK?

Avatar

Community Advisor

Hi @RajatPanwar ,

 

Yes, if the previous data before changing composite key is not unique as per latest Composite key, either u can update the newly added primary key column to get the Unique key combination or delete the data.

 

Regards,

Pravallika