Informatica Technical Interview Questions

Latest Informatica Technical Interview Questions.

Professionals are invited to share the answers in the comment section.

1. Explain what are the different types of loading in Informatica?
2. Explain what is a deployment group and what is its use?
3. What do you mean by Dataware house key in Informatica?
4. What is meant by named cache?At what situation we can use it?
5. What is the basic language of Informatica?
6. Explain the difference between stop and abort?
7. What is the use of control break statements in Informatica?
8. Can you tell me where persistent cache will be stored?
9. While running a Session in Informatica, what are the two files it will create?
10. Can Informatica load heterogeneous targets from heterogeneous sources?
11. Explain the main Architectural difference between Informatica 7.1 and 5.1?
12. How can you find out whether or not the newly added rows in the source are gets insert in the target? 
13. Explain dow do you recover a session or folder if you accidentally dropped them?
14. How can you create the staging area in your database?
15. How will you do SQL performance tuning?
16. Is it possible to run one loading session with one particular target and multiple types of data sources?
17. Explain what are Target Options on the Servers? 
18. What are the different join types in joiner transformation?
19. What are the different types of lookup in Informatica? 
20. What do you mean by Global repository in Informatica?
21. Explain what is difference between a connected look up and unconnected look up?
22. What is meant by source is changing incrementally? Can you explain with example ?
23. Can you tell what is the best way to modify a mapping if the target table name is changed?
24. What is the difference between Stored Proc (DB level) & Stored proc trans (INFORMATICA level)
25. Explain what is the use of Factless Fact table in Informatica?
26. Where should you place the flat file to import the flat file defintion to the designer? 
27. Can two flat files be joined with Joiner Transformation?
28. Explain in detail about Key Range & Round Robin partition with an example.
29. How can you recover the session in sequential batches? 
30. How can you select duplicate rows using Informatica?
31. How do you define Informatica server?
32. Explain how will you find whether your mapping is correct or not without connecting session?
33. Is there any relationship between Java and Informatica?
34. Explain what are Target Types on the Server? 

Related Posts