Share via

multiple lookup in copy activity

Vineet S 710 Reputation points
2024-07-06T02:27:07.44+00:00

Hi,

how to handle multiple lookup column as input in copy activity

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,815 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,479 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 31,791 Reputation points MVP
    2024-07-06T06:03:36.7+00:00

    As all the tables are within the same database, you can create a SQL query joining all tables ( assuming they can be joined)

    and use that query within the lookup activity/script activity .

    Else you can use a for each activity and make the query dynamic and iterate over the queries via loop in meta data driven frameway

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.