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. What are the Components of the Aggregator Transformation? Ans:- Aggregate cache, Aggregate expression, Group by port & […]
Read MoreCategory: PowerCenter Certification
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 actions performed by Active Transformations? Ans:- Change the number of rows that pass through the transformation, Change […]
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 are the various tasks can be performed by Lookup Transformation? Ans:- Get a related value, Get multiple values, Perform a calculation, Update slowly changing dimension […]
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 go through various topics as per syllabus. Just follow me, will do it together and become informatica certified specialists. 🙂 What is the primary unit for […]
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 Perspective. About the Informatica Certified Professional (ICP) Program Informatica certification is a two-stage structure that correlates professional certification with the “what, why and how” of […]
Read More