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?
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @god_prophet ,
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,
Regards,
Pravallika.
Hi @god_prophet ,
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,
Regards,
Pravallika.
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.
Views
Replies
Total Likes
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.
Views
Likes
Replies
Views
Likes
Replies