Informatica Interview Questions asked in MNCs

Informatica Interview Questions asked in MNCs.

Professionals are invited to share the answers for the questions cited below.

1. Explain what are the joiner caches in Informatica?
2. What are the different types of mapping in Getting Started Wizard?
3. Explain what is the difference between constraint based commit and target based commit?Under what circumstances we use constraint based?
4. What do you mean by metadata reporter in Informatica? 
5. Differentiate between summary filter and detail filter.
6. Explain what is the use of incremental aggregation? Explain me in brief with an example.
7. Can you tell me where do we use LKP b/n source to stage or stage to target?
8. Why and where do we use factless fact table?
9. Can we create duplicate rows in star schema, If yes then how?
10. Explain in detail about Performance tuning in Informatica?
11. Explain how can you say that union Transformation is Active transformation.
12. How do you delete duplicate rows in flat files source is any option in Informatica?
13. How do you create header and footer in target using Informatica?
14. What do you mean by a look up function? What is default transformation for the look up function?
15. Define Micro Strategy? Why is it used for? Can you explain in detail about it?
16. Explain what is the difference between truncate and delete statements?
17. What is the use of Shared Folder in Informatica?
18. Where we use Star Schema & where Snowflake?
19. Why can't we use normalizer transformation in mapplet?
20. Can we eliminate duplicate rows by using filter and router transformation ?if so explain me in detail .
21. Explain in brief about pmcmd in Informatica?
22. What do you mean by a junk dimension in Informatica?
23. How can you test mapping and what is associate port?
24. How do you do aggregation with out using AGGREGAROR Transformation ?
25. What are the locks with respect to mappings? How do you manually lock or unlock the mappings for changes?
26. Explain how can you stop a batch in Informatica? 
27. What is difference between COM  and DCOM?
28. How do you setup a schedule for data loading from scratch in Informatica?
29. Can you mention the various test procedures to check for whether the data is loaded in the backend, performance of mapping, and quality of the data loaded in Informatica
30. What are the active and passive transformations in Informatica? 
31. Explain what are the types of mapping wizards that are to be provided in Informatica? 

Related Posts