Can we perform a Join using more than one key in the Join transformation?

Yes, we can perform a join action using more than a one join key in the Join transformation. On the Join Transformation Properties screen, there is an option for Left Field and Right Field where you specify the key fields from both the incoming datasets based on which the Join action is to be performed.

joinkeys