Informatica Set 11

Which one is the correct format of ADD_TO_DATE function?

Can we perform calulation in Look up?

Which type of  join keeps all rows of data from both the master and detail sources?

Which are the true statement to improve session performance in joiner ?

Which type of join join keeps all rows of data from the master source and the matching rows from the detail source?

To maximize session performance what are the tips for filter transformation?

Is Filter is case-sensitive?

If two tables emp_detail and emp_payroll contain EMP_ID1 and EMP_ID2 with a row with a null value, can joiner will match that null value?

Which type of join keeps all rows of data from the detail source and the matching rows from the master source?

Can you use sorted input if source data is data driven?

To configurehow the Integration Service applies the transformation logic to incoming data, which one  you can choose  of the following values

Can you use sorted input if the session uses incremental aggregation?

Can you use sorted input if aggregate expression contains nested aggregate functions?

Whitch guidelines are needful  to optimize the performance of an Aggregator transformation?

INSTR( 'Vivek', 'a' ). What will be output?