I am trying to join multiple tables using the gui. However, I am not seeing any options available. It's primarily allowing joining of two tables. In case we would like to join multiple tables, there's a SQL Task "SQL Component" available where we can write the SQL script to have multiple table Joins. Is there any other GUI options.
In Matillion, there's no option available apart from the "SQL Component" . Please check all the videos of Matillion. I had a discussion with their customer care and they have confirmed. Multiple tables can be joined by writing SQL script in the "SQL Component"