Un-Answered Questions { Informatica }

What is meant by lookup transformation?

593


What are the new features of informatica 9.x developer?

511


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

625


What is mapping debugger?

549


Mention a few design and development best practices for informatica?

536


How can we store previous session logs?

544


What can we do to improve the performance of informatica aggregator transformation?

590


How an expression transformation differs from aggregator transformation?

599


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

609


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

611


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

533


How does a rank transform differ from aggregator transform functions max and min?

640


What is xml source qualifier transformation in informatica?

687


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

762


What differs when we choose the sorted input for aggregator transformation?

546