Hey @Girish13 ,
Can you please provide us the data loading architecture which you have?
Because there are multiple ways to achieve SCD 2:
- ELT process
ADF would copy the data into a staging table in the data warehouse.
The SCD logic would be implemented within a stored procedure in AEDW.
In that scenario, you can create variable within the stored procedure for insert, update,delete counts and log it into the logging table.
The copy activity provides only the rows transferred count and not update/delete counts.
2) You can even achieve SCD via data flow tasks and get the needed count via activity output :
Everything depends on the architecture which you currently have