What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
1 1556Suppose 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?
1099Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
1091Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
1132Post New Informatica Questions
Can we create multiple integration service on single repository?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the static cache and dynamic cache in informatica?
wat are deployement groups in informatica, how it will be used for developers
What is fact table? Explain the different kinds of facts.
How do you handle two sessions in Informatica
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the use of code page?
What the difference is between a database, a data warehouse and a data mart?
Define pmcmd command?
How does a sorter cache works?
what is song in infrmatica...?
What is aggregate cache in aggregator transformation?
Mention a few design and development best practices for informatica?
What is mapplet in informatica?