Describe the impact of number of join conditions and join order in a Joiner Transformation.

We can define one or more conditions based on equality between the specified master and detail sources. Both ports in a condition must have the same datatype. If we need to use two ports in the join condition with non-matching datatypes we must convert the datatypes so that they match. The Designer validates datatypes in a join condition.
Additional ports in the join condition increases the time necessary to join two sources.
The order of the ports in the join condition can impact the performance of the Joiner transformation. If we use multiple ports in the join condition, the Integration Service compares the ports in the order we specified.
NOTE: Only equality operator is available in joiner join condition.