What is source based commit? Ans:- The Integration Service commits data to the target based on the number of rows from some active sources in a target load order group. […]
Read MoreTag: Certification
Informatica certification – Rank Transformation
How many Ranks ports are allowed in a Rank Transformation? Ans:- Only ONE. What is RANKINDEX? Ans:- It is an output port to which the integration service store the ranking position for […]
Read MoreInformatica certification – Update Strategy Transformation
Update Strategy Transformation – My Notes How rows are flagged for insert, update, delete, or reject within a mapping? Ans:- Using Update Strategy transformation. We can also use the Custom […]
Read MoreInformatica certification – Aggregator Transformation
Aggregator Transformation – My Notes What is the use of Aggregator Transformation? Ans:- Aggregator transformation can be used to aggregate calculations (Avg, Sum, Max ..) on groups. Since its changing […]
Read MoreInformatica certification – Transformations
Working with Transformations – My Notes — Transformation Overview — Which is the repository object that generates, modifies, or passes data? Ans:- A Transformation. Which transformation performs calculations on groups […]
Read MoreInformatica certification – Lookup Transformation
Lookup Transformation – My Notes What is Lookup transformation? Ans:- It can be used to look up data in a flat file, relational table, source Qualifier, view, or synonym. What […]
Read MoreInformatica Certification – My Notes
The below question and answers are my preparation notes for Informatica Developer Specialist certification which I am planning to take some time in June. I will continue update this page as i […]
Read MoreInformatica Certification Developer Specialist
PowerCenter Data Integration 9.x: Developer, Specialist Certification This is Skill set Inventory document from Oracle website. Here you will get all the information which is required for the Informatica certification […]
Read More