What is the point of a full join in Magic ETL?
So I get Left, right, and inner joins. But, what is the point of a full join if it returns null values for any columns that don't have a match? How is that different from an inner join?
Also, how can I make sure that the non-matched items are included in the resulting dataflow?