Un-Answered Questions { Informatica }

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

565


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?

692


What is mapping debugger?

602


Mention a few design and development best practices for informatica?

598


How can we store previous session logs?

599


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

650


How an expression transformation differs from aggregator transformation?

656


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

655


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

686


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?

586


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

714


What is xml source qualifier transformation in informatica?

751


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?

820


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

594


What do you understand by term role-playing dimension?

626