Home » Informatica Certification

Informatica 10 Developer Specialist Certification – Enroll Now!

When You Are Ready To Test: Informatica Specialist Certifications are available Anytime/Anywhere. To become an Informatica Certified Specialist (ICS), please follow these steps. 1. Go to the Informatica Certification Trainings located here. 2. Login with your Informatica Passport…

Read More »

Informatica 10 Certification – Sample questions

PowerCenter Data Integration 10: Developer, Specialist Certification This test measures your competency in building PowerCenter objects on basic and advanced levels in order to make optimal use of the Designer, Workflow Manager and Workflow Monitor tools. Additionally you…

Read More »

Informatica 10 Certification – Developer Specialist

PowerCenter Data Integration 10: Developer, Specialist Certification This test measures your competency in building PowerCenter objects on basic and advanced levels in order to make optimal use of the Designer, Workflow Manager and Workflow Monitor tools. Additionally you…

Read More »

XML Transformations

XML Transformations in Informatica What are the different types of XML transformations? Ans:- XML Source Qualifier Transformation, XML Parser Transformation and XML Generator Transformation. What is XML Source Qualifier transformation? Ans:- It defines the data elements that the…

Read More »

SQL Override​ in Informatica​

We have an option to customize the default query provided by the transformations and enter custom SQL query by using SQL override. The most common transformations which support the SQL overrides are Source Qualifier & Lookup transformations. If…

Read More »

Informatica certification – Commit Points

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

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

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

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

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

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

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

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 »