What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
1 876Suppose 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?
631Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
639Post New Informatica Questions
How to extract sap data using informatica?
What is option by which we can run all the sessions in a batch simultaneously?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is an expression transformation in informatica?
What do you mean by enterprise data warehousing?
Describe an informatica powercenter?
What is the difference between informatics 7x and 8x and what is latest version?
What is the advantage of informatica?
Explain the pipeline partition with real time example?
What is blocking transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
whats the logic to load the lower level of granularity of data to fact table.
Difference between Target-based loading and constraint-based loading?
What's the layout of parameter file (what does a parameter file contain?)?