Forum Discussion
What is the best strategy for combining data?
Hi
I have a dataflow in datafactory that concists of many joins. Each joins has the responsibility of adding new data to the inital object.
Are you aware of better strategies other than joining?
Thanks
1 Reply
The optimal approach for combining data in Azure Data Factory depends on the characteristics of the source systems and the specific transformation requirements. While join transformations are frequently used, Microsoft recommends evaluating alternative options such as Lookup, Union, or Derived Column transformations where applicable. These alternatives can streamline data flows, reduce complexity, and improve overall performance.
https://learn.microsoft.com/en-us/azure/data-factory/data-flow-join
https://learn.microsoft.com/en-us/azure/data-factory/data-flow-lookup
