locked
How to perform JOIN operation in Azure Data Factory RRS feed

  • Question

  • I am trying to join two files from the blob storage and save into SQL server,
    Thursday, October 20, 2016 3:44 AM

All replies

  • As far as I know, there is no join function on blob connector.

    I think you can implement the custom activity, and writing code by yourselves.

    Here is the doc:

    https://azure.microsoft.com/en-us/documentation/articles/data-factory-use-custom-activities/

    Or your can try sproc activity: copy those 2 files data into SQL first. Then write a SP to join data and insert data to target table.

    Here is the doc:

    https://azure.microsoft.com/en-us/documentation/articles/data-factory-stored-proc-activity/

    Thursday, October 20, 2016 4:35 AM