Lookup activity in Azure Data Factory is different from the lookup activity present in SSIS. Lookup activity in Azure Data Factory is used to execute Stored Procedure with output.
It can return the first row or multiple rows of data from the stored procedure. The output can be used to input for each loop.
The lookup activity supports a max of 5000 rows as output.
For more details, please check the following https://docs.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity documentation
It can return the first row or multiple rows of data from the stored procedure. The output can be used to input for each loop.
The lookup activity supports a max of 5000 rows as output.
For more details, please check the following https://docs.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity documentation
No comments:
Post a Comment