Informatica Interview Questions Collection

Informatica Technical Interview Questions asked in companies like CTS, IBM, HP, TCS, Wipro, Infosys, Cap Gemini,Tech Mahindra,

Please use the comment section to answer. Learn about the Informatica Questions in major companies.

1. Can you tell me which all databases PowerCenter Server on Windows can connect to?
2. At the max how many transformations can be us in a mapping in Informatica?
3. Compare Data Warehousing Top-Down approach with Bottom-up approach
4. Explain in brief how can we populate the data into a time dimension ?
5. How can you decide whether you need to do aggregations at database level or at Informatica level?
6. How many types of flat files available in Informatica?
7. What are cost based and rule based approaches and the difference
8. Explain what are the difference between view and materialized view?
9. Explain in brief what are the reusable transformations in Informatica? 
10. What are worklets and what is their use?
11. What do you mean by auxiliary mapping in Informatica?
12. How do you partition the Session in Informatica?
13. What do you mean by incremental loading?What is versioning ?
14. What do you mean by Shortcut? Explain its usage.
15. Explain in brief what is the difference between Normalizer and Normalizer transformation.
16. What is the practical use of a union transformation?
17. When and how a partition is defined using Informatica?
18. Which ETL tool is more preferable Informatica or Data Stage and give reasons why?
19. At what frequency you load the data in Informatica?
20. Could you tell me what are the steps required for type2 dimension/version datamapping. How can we implement it?
21. How can we remove or optimize source bottlenecks using "query hints"?
22. Explain how can you define a parameter file? Give an example of its use.
23. How many types of sessions are available in Informatica. Please explain them.?
24. How to perform a "Loop Scope / Loop condition" in an Informatica program ? Give me few examples
25. Explain in brief what are data driven sessions in Informatica?
26. Explain what are the Differences between Informatica Power Center versions 6.2 and 7.1, also differentiate between Versions 6.2 and 5.1?
27. What are the scheduling options to run a session in Informatica? 
28. What do you mean by Bulk and Normal load? Where we use Bulk and where Normal?
29. What do you mean by batch. Describe about types of batches? 
30. What do you mean by Informatica basic data flow?
31. What is source based commit and target based commit with an example ? What is the background process that will be done if you select source based commit or target based commit ?
32. What is the difference between Power Centre and Power Mart?What is the procedure for creating Independent Data Marts from Informatica 7.1 in Informatica?
33. What is the procedure or steps implementing versioning if you are already in version7.X?

Related Posts