Differentiate between sessions and batches?
What is the different lookup cache(s)?
What is a repository manager?
What is the use of an aggregator cache file?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the need for an etl tool?
Explain the shared cache and re-cache?
What are the features of complex mapping?
What is a filter transformation and why it is an active one?
What is a rank transform?
What is meant by lookup transformation?
What are the new features of informatica 9.x developer?
Suppose 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?
What is mapping debugger?
Mention a few design and development best practices for informatica?