What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
1 874Suppose 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?
656Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
630Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
636Post New Informatica Questions
What is aggregate cache in aggregator transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to generate sequence numbers?
Enlist the differences between database and data warehouse.
What are the mapping parameters and mapping variables?
How will the document be delivered to me?
How can you generate reports in informatica?
How to handle decimal places while importing a flatfile into informatica?
what is mean by complex business rule ?
How can we create index after completion of load process?
Can we create a Integration service without a Repository service and vice versa?
difference between repository database and repository service?
what is the complex transformation you used in informatica
How would you copy the content of one repository to another repository?
explain about unit testing? in real time?