Informatica Interview Question

SQL related questions, like join.