What do you mean incremental aggregation?
What is a pre-defined event and user-defined event?
How do you load first and last records into target table?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
What is an expression transformation in informatica?
What are the join types in joiner transformation?
How to configure mapping in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
What is a predefined event?
4 yrs etl devloper roles and responsibilities?any body give solutions
How can we use mapping variables in informatica? Where do we use them?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C