Sharing Knlowledge With The World…

Month: November 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?

Please provide your name and email address for your free download.

Continue Reading

Top Informatica Questions Asked In Interviews

Hi Folks , from this post onwards we will be posting some Top Informatica Questions that are generally being asked in Interviews.

1. How do u change parameter when u move it from development to production. ?
2. How does the session recovery work. ?
3. why use shortcuts(Instead of making copies). ?
4. where is the reject loader and how to use it. ?
5. Do you have to change the reject file before using reject
loader utility. ?
6. Differences between current and previous versions. ?
7. Debugger – what are the modules, what are the options
you can specify when using debugger, can you change the
expression condition dynamically when the debugger is running ?
8. Mapplets – can you use an active transformation in a Mapplet ?
9. What are active transformations?
10. Can u use flat files in Mapplets ?
11. How many transformations can be used in mapplets. Is there any specified limit ?
12. Can a joiner be used in a mapplet?
13. How can you join 3 tables? Why cant you use a single Joiner to join 3 tables
14. Global and Local shortcuts. Advantages.
15. Mapping variables, parameters syntax, if you create mapping variables
and parameters in mapplet can u use them in the mapping?
16. Have you worked with/created Parameter file
17. What’s the layout of parameter file (what does a parameter file contain?)?
18. Why do we use Mapping Parameter and mapping variable?
19. Session Recovery. 1000 rows in the source of which 500 passed
through and then I killed the session. Can you perform a recovery and how ?
20. What are the modules in Power Center ?
21. filter transformation in the condition one of the data is NULL would the record be dropped.?
22. Implement all three SCD’s using Informatica and with different approaches. ?
Please Leave your comment if you have any query
Subscribe US!!! to get the free PDF copy of Answers

Continue Reading