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?
1100Suppose 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
Explain how many types of dimensions are available in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How to handle decimal places while importing a flatfile into informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How does a sorter cache works?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Differentiate between a database and data warehouse?
What is Session and Batches?
Describe an informatica powercenter?
Explain the aggregator transformation?
What is a difference between complete, stop and abort?
What are the differences between joiner transformation and source qualifier transformation?
What is data transformation manager process?
How you can differentiate between connected lookup and unconnected lookup?
Explain sessions. Explain how batches are used to combine executions?