108 Informatica Power center Interview Q&A in Simple Words – 2025 Edition
💡 Learn Informatica Power center from scratch – Practical, real-life questions with clear answers
by Rishab Informatica Group
1. What is Informatica PowerCenter?+
2. What are the features of complex mapping?+
3. What is the meaning of Enterprise Data Warehousing?+
4. What is the meaning of Lookup transformation?+
5. What are the points of difference between connected lookup and unconnected lookup?+
6. How many input parameters can be present in an unconnected lookup?+
7. How many lookup caches are available?+
8. What is the difference between a data warehouse, a data mart, and a database?+
9. What is a domain?+
10. What is the difference between PowerCenter and Repository server?+
11. In Informatica, how many repositories are possible to be made?+
12. What are the benefits of a partitioned session?+
13. Define parallel processing?+
14. What are the different types of methods for the implementation of parallel processing in Informatica?+
15. What are the different mapping design tips for Informatica?+
16. What is the meaning of the word 'session'?+
17. How many numbers of sessions are grouped in one batch?+
18. What is the difference between mapping parameters and mapping variables?+
19. Explain Partitionings & types in performance tuning?+
20. What are the best mapping development practices?+
21. What are the features of complex mapping?+
22. Which option helps in finding whether the mapping is correct or not?+
23. What do you mean by OLAP?+
24. Mention the different types of OLAP?+
25. What is the meaning of the surrogate key?+
26. What is a session task?+
27. What is the meaning of the command task?+
28. What is the meaning of a standalone command task?+
29. Define workflow?+
30. How many tools are there in the workflow manager?+
31. Define target load order?+
32. Define Power Centre repository of Informatica?+
33. Name the scenario in which the Informatica server rejects files?+
34. How to use Normalizer Transformation in Informatica?+
35. What are the Limitations of Pushdown Optimization?+
36. What is the difference between Copy and Shortcut?+
37. How to use PMCMD Utility Command?+
38. How do I scheduling a Workflow?+
39. What is Dynamic Lookup Cache?+
40. What is the difference between the variable port and the Mapping variable?+
41. Which is the T/R that builds only single cache memory?+
42. What is XML Source Qualifier Transformation in Informatica?+
43. What is Snowflake Schema?+
44. What is a Standalone Email task?+
45. What is Mapping Debugger?+
46. What is the functionality of F10 in Informatica?+
47. What are Worklet and what types of worklets?+
48. What is Relative Mode?+
49. What is the Difference between Filter and Router T/R?+
50. What is a Repository Manager?+
51. What is Rank Transformation in Informatica?+
52. What is meant by Informatica PowerCenter Architecture?+
53. What is Workflow Monitor?+
54. If Informatica has its own scheduler why using a third-party scheduler?+
55. What is Workflow Manager?+
56. What is Informatica PowerCenter?+
57. What is a Dimensional Model?+
58. How does Rank transformation handle string values?+
59. Is a sorter an active or passive transformation?+
60. Mention the types of transformations available in Informatica.+
61. What is the difference between active and passive transformation?+
62. What are the output files created by the Informatica server at runtime?+
63. What is the difference between static cache and dynamic cache?+
64. Can you tell what types of groups does router transformation contains?+
65. How do you differentiate stop and abort options in a workflow monitor?+
66. Is it possible to store previous session logs in Informatica?+
67. What do you know about Data-Driven sessions?+
68. What is a Mapplet in Informatica?+
69. What is the difference between Mapping and Mapplet?+
70. List the transformations used for SQL override.+
71. State the differences between SQL override and Lookup override.+
72. What is a shared cache?+
73. Explain code page compatibility.+
74. Define Expression transformation?+
75. What is Aggregator transformation?+
76. What do you know about filter transformation?+
77. Why is union transformation active?+
78. What is the use of incremental aggregation in Informatica?+
79. What does reusable transformation mean?+
80. How does update strategy work in Informatica?+
81. Differentiate Informatica and Datastage.+
82. Explain transaction control transformation.+
83. What is a reusable session?+
84. How to handle NULL values in expressions?+
85. What is constraint-based loading?+
86. What is a persistent cache?+
87. What is a pre-session command?+
88. What is a worklet?+
89. What is the stop-on-errors property?+
90. What is a target load plan?+
91. What is a source filter?+
92. What is a stored procedure transformation?+
93. What is a transaction control transformation?+
94. What is a union transformation?+
95. What is a joiner transformation?+
96. What is a router transformation?+
97. What is a sequence generator?+
98. What is a normalizer transformation?+
99. What is a pushdown optimization?+
100. What is a grid in PowerCenter?+
101. What is a node in PowerCenter?+
102. What is a domain?+
103. What is a repository service?+
104. What is an integration service?+
105. What is a workflow manager?+
106. What is a workflow monitor?+
107. What is pmcmd?+
108. What is a deployment group?+
