question

srk-3923 avatar image
0 Votes"
srk-3923 asked SaurabhSharma-msft commented

Join transformation in mapping data flow Azure

Hi there,

Small information if any can able to.

I have 4 SQL tables that I need to join to populate the dimension

As I can write SQL queries to join them but I don't want to do because of the cost of the services.

I thought to use Join transformation but it allows only 2 input streams, not 4, for this, I need to use multiple join transformations but will be very expensive.

Is there any other way to join more than 2 tables in one go except SQL script? Please let me know

Many thanks
SRK

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

To join more than 2 streams, just add another Join transformation. It is not any more expensive.

0 Votes 0 ·

@srk-3923 Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

0 Votes 0 ·

1 Answer

nasreen-akter avatar image
0 Votes"
nasreen-akter answered

Hi @srk-3923,

Thank you for the ask. There is a Table, Query or SP Input options if you go to the SQL Source --> "Source Option", you can write the Query there. Please see the screenshot below. Hope this helps! Thanks!

88560-33.jpg



33.jpg (54.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.