Azure Data Factory SCD Type 1 with Mapping Data Flows

[@masoudpesaran9721]

the column 'LastUpdated' did not updated after you changed the SCD type 1 columns! It looks to me that the formula for this column in your 'SetAttribute' needs to be fixed. It must simply be: 'currentTimestamp()'. Please see: Exercise - Design and implement a Type 1 slowly changing dimension with mapping data flows - Learn | Microsoft Docs

[@montoyescoful]

On the Exists Task, Can I put, not only the hash, but the key column too as an additional field below? I suppose with this modification, the Lookup Task will be no longer necessary.

[@PatrickAlexanderThePilot]

Can you share the source code for dataflow? I have exact same problem to solve and it will help me a lot to look into your sample code

[@MSDataFactory]

Here is the link to the Data Flow activity JSON … I'll post it in the video description as well: github.com/kromerm/dataflowdemos/blob/collab/dataflow/scdHash.json

[@nithindesani2711]

Video is in 360P, Can you please upload in HD?

[@MSDataFactory]

Should be HD now