Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Is there a way we can lookup on Binary Hash/table to determine the data exist or changed records using ADF?
Hi @Vishal4u ,
I think you can refer to the following steps to check it out.
1. Choose which data stream you're checking for existence in the Right stream dropdown.
2. Specify whether you're looking for the data to exist or not exist in the Exist type setting.
Load data with computed hash values into a database table.
1. Extract new data and compute hashes.
2. Join new data with existing data based on key columns to compare hashes.
3. Identify new or changed records (where new hash != existing hash).
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sounds interesting, but my question was from a azure data factory?
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |