November 24, 2014
Top Informatica Questions And Answers
Hey Folks, As Discussed in our earlier post this our subsequent post regarding Informatica Interview Questions. please subscribe to get the free copy of PDF with answers and leave a comment.
Informatica Questions And Answers :-
1) What is the difference between reusable transformation & shortcut created ?
2) Which one is true for mapplets ( can u use source qyalifier, can u use sequence generator, can you use target) ?
3) What are the ways to recover rows from a failed session ?
4) Sequence generator, when u move from development to production how will you reset ?
5) What is global repository ?
6) How do u set a variable in incremental aggregation ?
7) What is the basic functionality of pre-load stored procedure ?
8) What are the different properties for an Informatica Scheduler ?
9) In a concurrent batch if a session fails, can u start again from that session ?
10) When you move from development to production then how will you retain a variable value ?
11) Performance tuning( what was your role) ?
12) what are conformed dimensions?
13) Can you avoid static cache in the lookup transformation? I mean can you disable caching in a lookup transformation?
14) What is the meaning of complex transformation?
15) In any project how many mappings they will use(minimum)?
16) How do u implement un-connected Stored procedure In a mapping?
17) Can you access a repository created in previous version of Informatica?
18) What happens if the info. Server doesn’t find the session parameter in the parameter file?
19) How did you handle performance issues If you have data coming in from multiple sources, just walk through the process of loading it into the target
20) How will u convert rows into columns or columns into rows
21) What are the steps involved in the migration from older version to newer version of Informatica Server?
22) What are the main features of Oracle 11g with context to data warehouse?
24) How to run a session, which contains mapplet?
25) Differentiate between Load Manager and DTM?
26) What are session parameters ? How do you set them?
27) What are variable ports and list two situations when they can be used?
28) Describe Informatica Architecture in Detail ?
29) How does the server recognise the source and target databases.
30) What is the difference between sequential batch and concurrent batch and which is recommended and why?
31) A session S_MAP1 is in Repository A. While running the session error message has displayed
‘server hot-ws270 is connect to Repository B ‘. What does it mean?
32) How do you do error handling in Informatica?
33) How can you run a session without using server manager?
34) Consider two cases:
1. Power Center Server and Client on the same machine
2. Power Center Sever and Client on the different machines
what is the basic difference in these two setups and which is recommended?
35) Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
36) What is the difference between normal and bulk loading? Which one is recommended?
37) What is a test load?
38) How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
39) What are Business Components in Informatica?
40) What is the advantage of persistent cache? When it should be used.
41) When will you use SQL override in a lookup transformation?