Dinesh Madhup
Dinesh Madhup

Reputation: 367

How to use Join in Data Flow of Azure Data Factory efficiently?

If I have 4 sources to join in table then should I need 4 join activity in graph of data flow? Is there any way to minimize Join activity. For example: Suppose there are 20 sources to join then it will be more complex.

enter image description here

Upvotes: 0

Views: 350

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

Join active only support two input streams. If your sources are in same database, you could try use query to let the join be simple.

Just for now, there's a good solution for this even it will be more complex.

Upvotes: 1

Related Questions