Top Informatica Interview Questions & Answers

4.80 avg. rating (95% score) - 5 votes
informatica interview questions


Informatica Powercenter (also simply called Informatica) is a popular ETL (Extract, Tranform, Load) or data integration tool which is a widely used tool developed by the American software development company, Informatica. It is very powerful and delivers the right data to help the needs of the users.

Data professionals have always played an important role in any business related to any industry. Professionals who are experts in Informatica are also in great demand. If you are appearing for Informatica interview, you can take the help of the following commonly-asked Informatica interview questions (with answers):


Q1. Differentiate between a database, a data warehouse and a data mart?


Ans. Database includes a set of sensibly affiliated data which is normally small in size as compared to data warehouse, whereas in a data warehouse there are assortments of all sorts of data from where data is taken out only according to the customer’s needs. Datamart is also a set of data which is designed to cater the needs of different domains.


Q2. What is a Sorter Transformation?


Ans. Sorter transformation helps us sort collections of data by port or ports.


Q3. What is an Expression Transformation?


Ans. An expression transformation is a common Powercenter mapping transformation.


Q4. What is Joiner Transformation?


Ans. The joiner transformation is an active and connected transformation used to join two heterogeneous sources.


Q5. What is a Decode in Informatica?


Ans. A decode in Informatica is a function used within an Expression Transformation.


Q6. What is a Router Transformation?


Ans. The Router Transformation allows users to split a single pipeline of data into multiple.


Q7. What is a Rank Transformation?


Ans. The Rank Transformation lets users to sort and rank the top or bottom set of records based on a specific port.


Q8. What is a Filter Transformation?


Ans. Filter transformation is used to filter out rows in a mapping. It is active and connected.


Q9. What is a Sequence Generator Transformation?


Ans. It is used to generate primary key values, or a range of sequence numbers for calculations or processing. It is passive and connected.


Q10. What is a Master Outer Join?


Ans. A master outer join is a specific join type setting within a joiner transformation.


Also Read>> Online Learning Vs Traditional Learning!


Q11. What are some examples of Informatica ETL programs?


Ans. Some of the programs are mappings, workflow and task.


Q12. Explain dimensional tables?


Ans. Dimension tables contain attributes that describe fact records in the table.


Q13. What is star schema?


Ans. It is the simplest form of data warehouse schema that consists of one or more dimensional and facts tables.


Q14. Describe snow flake schema?


Ans. It is a fact table which is connected to a number of dimensional tables.


Also Read>> What do Online Courses Have to Offer?


Q15. What is a mapplet?


Ans. Mapplet is essential to create reusable mappings in Informatica.


Q16. What is a natural primary key?


Ans. A natural primary key uniquely identifies each record within a table and relates records to additional data stored in other tables.


Q17. What is a surrogate key?


Ans. It is used in substitution for the natural primary key


Q18. What is the difference between a repository server and a powerhouse?


Ans. Repository server controls the complete repository which includes tables, charts, and various procedures etc.

A powerhouse server governs the implementation of various processes among the factors of server’s database repository.


Also Read>> Lifelong Learning: A Chance to Follow Your Heart and Carve Your Own Path!


Q19. How many repositories can be created in informatica?


Ans. As many as required.


Q20. Describe Data Concatenation?


Ans. Data concatenation is the bringing of different pieces of record together.


Q21. How can one identify whether mapping is correct or not without connecting session?


Ans. With the help of debugging option.


Q22. Name the designer tools for creating transformations?


Ans. Mapping designer, transformation developer and mapplet designer.


Q23. Differentiate between sessions and batches?


Ans. Session is a set of commands for the server to move data to the target.

Batch is a set of tasks that can include one or more number of tasks.


Also Read>> Take That Big Career Leap with e-Learning!


Q24. What is the difference between static cache and dynamic cache?


Ans. In static cache the data will remain the same for the entire session, whereas in dynamic cache, whenever a row is inserted the cache will also be updated.


Q25. What is the command used to run a batch?


Ans. The pmcmd command.

These are some of the popular questions asked during an Informatica interviews. Always be prepared to answer all types of questions — technical skills, interpersonal, leadership or methodology. If you have recently started your career in a data profile, you can always get certified to understand the industry-related terminology, skills and methodologies.

About the Author

Hasibuddin Ahmed

Hasibuddin Ahmed

Hasib is a professional writer associated with He has written a number of articles related to technology, marketing, and career on various blogs and websites. As an amateur career guru, he often imparts nuggets of knowledge related to leadership and motivation. He is also an avid reader and passionate about the beautiful game of football.