Tag: Certification

Informatica certification – Commit Points

No Picture

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. What is One-to-One  mapping? Ans:- One-to-one mapping is a…

Read More »

Informatica certification – Rank Transformation

No Picture

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 each row in a group. Why Rank is…

Read More »

Informatica certification – Update Strategy Transformation

No Picture

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 transformation to flag rows for insert, delete, update,…

Read More »

Informatica certification – Aggregator Transformation

No Picture

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 the number of rows its an active transformation….

Read More »

Informatica certification – Transformations

No Picture

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 of data? Ans:- Aggregator Transformation. What are the…

Read More »

Informatica certification – Lookup Transformation

No Picture

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 are the various tasks can be performed by…

Read More »

Informatica Certification – My Notes

No Picture

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 go through various topics as per syllabus. Just…

Read More »

Informatica Certification Developer Specialist

No Picture

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 Perspective. About the Informatica Certified Professional (ICP) Program…

Read More »