What is the difference between truncate and delete statements?
Type 1 – DD_UPDATE,
Type 2 – DD_UPDATE/DD_INSERT
Type 3 – DD_INSERT.
What are the different ways to filter rows using Informatica transformations?
What is target load order?
Using a view also you can use lookup(which is nothing but a outer join).