If you want to see the code snippet which Informatica generates while creating a target table
--> generate and Execute.
If you want to see the code snippet which Informatica generates while joining...