If you want to perform insert, update, delete based on some conditional clause then you can choose this and when it is not possible for other types of update procedures in Informatica. (necessary condition is target should have a primary key.)