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