Does airbyte support join transformations for 2 sources? Where can I find the list of transformations that airbyte performs. Thank you

No, Airbyte doesn’t support join operations. You can apply them using dbt after running the syncs.