SG Analytics interview question

types of joins? optimization technique? Informatica basics ?