sensanjoy
Contributor II

Hi @Vijesh V​ 

Try to use merge into to perform cdc between tables :

MERGE INTO target a

USING source b

ON {merge_condition}

WHEN MATCHED THEN {matched_action}

WHEN NOT MATCHED THEN {not_matched_action}