Truncating a foreignkey? Consequences

[ogonzalesdiaz]

Hi, I've created a 1-to-1 relationship between table ABC and Recipients.

This question is related to this one.  

Now, We need to empty the table ABC every day, to ingest new data only. This is done using a SQL activity and doing a truncate on the table, so we only keep the headers.

Beign the relationship a foreign key with recipients, how would doing a truncate action on table ABC affect recipients?

[LakshmiPravallika · Accepted solution]

Hi @ogonzalesdiaz ,

In the given links , the attribute revIntegrity="normal" is defined, so it will initialize all the Foreign Keys if the deletion happened at the source Schema. 

So the truncate operation on ABC would only initialize the foreign keys of Recipient Schema.

PFA the documentation for reference,

https://experienceleague.adobe.com/en/docs/campaign-classic/using/configuring-campaign-classic/schem...

Regards,

Pravallika.

[ogonzalesdiaz]

Hi @LakshmiPravallika , 

Could you detail this part: "So the truncate operation on ABC would only initialize the foreign keys of Recipient Schema".

What is: only initialize? So records on Recipients won't be deleted?

I need only to delete (truncate) records on ABC.

[ogonzalesdiaz]

So according to me research, those foreign keys in the Recipients schema are set to null, so there are no orphan foreign keys.

No records are deleted in Recipients, due to  the attribute revIntegrity="normal".

Thank you, Pravallika.