What are the new features of informatica 9.x developer?
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?
What is mapping debugger?
Mention a few design and development best practices for informatica?
How can we store previous session logs?
What can we do to improve the performance of informatica aggregator transformation?
How an expression transformation differs from aggregator transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
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?
How does a rank transform differ from aggregator transform functions max and min?
What is xml source qualifier transformation in informatica?
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?
What differs when we choose the sorted input for aggregator transformation?
What do you understand by term role-playing dimension?