What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
1 1563Suppose 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?
1100Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
1094Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
1138Post New Informatica Questions
hi real timers . iam waiting for ur reply regarding ETL TESTING
State the differences between sql override and lookup override?
What is the difference between stop and abort in informatica
Does an informatica transformation support only aggregate expressions?
Write the program through which the records can be updated?
What is mapping debugger?
What are the informatica performance improvement tips
What is the meaning of decode in informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Define joiner transformation?
How can you increase the performance in joiner transformation?
What is the use of code page?
How to create or import flat file definition in to the warehouse designer?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?