So I have a query to compare the data, I want to compare between two table using If Else Condition on Azure Data Factory.
So here are dummy example T-SQL for the condition
BEGIN
SET @sales_detail_row = (select count(*)
from schema_A.SALES_DETAIL
where transaction between '2021-04-01' and '2021-05-16')
SET @pf_sales_detail_row = (select count(*)
from schema_B.SALES_DETAIL
where transaction between '2021-04-01' and '2021-05-16');
if (@sales_detail_row=@pf_sales_detail_row)
then print 'SUCCESS'
else
'FAILED'
END
How to implement these query into If Else Condition on Azure Data Factory ?
From this Source, I don't really understand, because no explanation about the query method.
Aucun commentaire:
Enregistrer un commentaire