0

I want to delete records from target table as records deleted from a source. I used merge/rows and delete stop both individuals, but I solved my problem in delete case when I deleted record from source. Then, after transformation fact table had only that record which was deleted from the source while it must had all those instead of this. I want the same method for the dim table also.enter image description here

Alejandro Galera
  • 3,445
  • 3
  • 24
  • 42
Adil
  • 11
  • 4
  • Is it possible to have a 4 line example of what you try to achieve? – AlainD Jan 05 '18 at 12:15
  • I have rental(source) table and want to sync with my warehouse fact_rental as any records deleted from a source that would be deleted in the warehouse too.Want to do on dim and fact table. I tried to delete step but not successful – Adil Jan 05 '18 at 12:23

0 Answers0