SG Analytics Interview Question

types of joins? optimization technique? Informatica basics ?