7 thoughts on “Azure Data Factory – Lookup Activity

  1. Syed Islam June 27, 2018 / 4:16 pm

    Hi Mitchell

    Great blog! Is there an email subscription for your blog? I couldn’t find any. Keep up the great work. Thanks!

    Syed

    • Mitchell Pearson June 27, 2018 / 5:54 pm

      Hey Syed, thanks for the great feedback. This blog needs to be updated and I will be working on making some updates in the next couple weeks and this should make it easier for users to subscribe. Thanks again!

  2. Fraz July 22, 2018 / 4:19 pm

    Hey Mitchell, thanks for this great post. I have a doubt here.

    1.We are pulling last modified date a file which is stored in a blob using meta data activity. This is clear and now Stored procedure is returning the last Execution Date from my Control Table so are we storing our data from file into a table?

    • Mitchell Pearson July 24, 2018 / 4:21 pm

      Hey Fraz,

      What you do with the last modified date depends on what business problem you are trying to solve. If you want to compare the last modified date of the file to the last execution date from a control table then you can do that comparison in Azure Data Factory and it’s not necessary to write that information to a table. I outline how to do this comparison in my latest ADF blog using the IfCondition activity. See link below: https://mitchellpearson.com/2018/07/02/azure-data-factory-if-condition-activity/

      Thanks for reading my blog!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s