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.… Continue reading Informatica certification – Commit Points
Tag: 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… Continue reading Informatica certification – Rank Transformation
Informatica 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… Continue reading Informatica certification – Update Strategy Transformation
Informatica 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… Continue reading Informatica certification – Aggregator Transformation
Informatica 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… Continue reading Informatica certification – Transformations
Informatica 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… Continue reading Informatica certification – Lookup Transformation
Informatica 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… Continue reading Informatica Certification – My Notes
Informatica 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… Continue reading Informatica Certification Developer Specialist