Interview Ques

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 5. how do you use reject loader 6. do u have to change the reject file b4 using reject loader utility 7. Differences between version 4.7 and 5.1 8. Differences between version 5.1 and 1.7 9. 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 4. Mapplets – can you use an active transformation in a mapplet, 5. What are active transformations? Name them 6. Can u use flat files in Mapplets 7. How many transformations can be used in mapplets 8. Can a joiner be used in a mapplet? 9. What are active transformations 12. How can you join 3 tables? Why cant you use a single Joiner to join 3 tables 13. Global and Local shortcuts. Advantages. 16. Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can u use them in the mapping? 17. Have you worked with/created Parameter file 18. What’s the layout of parameter file (what does a parameter file contain?)? 19. Why do u use Mapping Parameter and mapping variable? 20. Where do u create/define mapping parameter and mapping variable? 22. 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 23. Slowly changing dimensions, types and where will you use them 24. What are the modules in Power Center 25. filter transformation in the condition one of the data is NULL would the record be dropped. 1) parameter&variable differences 2) reusable transformation & shortcut differences 3) mapplets ( can u use source qyalifier, can u use sequence generator, can u use target) 5) implementation methodology 6) do u have knowledge in ralph kimball methodology 7) according to his methodology what all u need before u build a datawarehouse 9) how do u recover rows from a failed session 11)sequence generator, when u move from develoment to production how will u reset 13)whats there in global repository 14)repository user profiles 15)how do u set a varible in incremental aggregation 16)can u create a flatfile target 17)what did u do in source pre load stored procedure 18)scheduling properties,whats the default (sequential)

19)in a concurrent batch if a session fails, can u start again from that session 20)when u move from devel to prod how will u retain a variable 21)partition, what happens if the specified key range is shorter n longer 22)performance tuning( what u did in performance tuning) 6.what are conformed dimensions? 7.what are factless facts? And in which scenario will you use such kinds of fact tables. 8.can you avoid static cache in the lookup transformation? I mean can you disable caching in a lookup transformation? 9.what is the meaning of complex transformation? 10.in any project how many mappings they will use(minimum)? 10• How do u implement unconn. Stored proc. In a mapping? 11• Can u access a repository created in previous version of Informatica? 12• What happens if the info. Server doesn’t find the session parameter in the parameter file? 31. How big was your fact table 32. How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target 33. How will u convert rows into columns or columns into rows 4. What are the steps involved in the migration from older version to newer version of Informatica Server? 7. What are the main features of Oracle 8i with context to datawarehouse? 2. What are the new features of Power Center 5.0? 3. How to run a session, which contains mapplet? 4. Differentiate between Load Manager and DTM? What are session parameters ? How do u set them? When do u use mapping parameters? (In which transformations) What is a parameter When and where do u them when does the value will be created Desing time, run time. If u don’t create parameter what will happen 5. What are variable ports and list two situations when they can be used? 6. What are the parts of Informatica Server? 7. How does the server recognise the source and target databases. Elaborate on this. 8. List the transformation used for the following: a) Heterogeneous Sources b) Homogeneous Sources c) Find the 5 highest paid employees within a dept. d) Create a Summary table e) Generate surrogate keys 9. What is the difference between sequential batch and concurrent batch and which is recommended and why? 14. 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? 15. How do you do error handling in Informatica?

16. How do you implement scheduling in Informatica? 17. What is the meaning of up gradation of repository? 18. How can you run a session without using server manager? 21. 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? 22. 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? 23. When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why? 24. What is the difference between normal and bulk loading? Which one is recommended? 25. What is a test load? 27. How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use? 28. What is the difference between a shortcut of an object and copy of an object? Compare them. 29. What is mapplet and a reusable transformation? 30. How do you implement configuration management in Informatica? 31. What are Business Components in Informatica? 32. Dimension Object created in Oracle can be imported in Designer 33. Cubes contain measures 34. COM components can be used in Informatica 36. What is the advantage of persistent cache? When it should be used. 37. When will you use SQL override in a lookup transformation? 38. Two different admin users created for repository are ______ and_______ 39. Two Default User groups created in the repository are ____ and ______ 40. A mapping contains • Source Table S_Time ( Start_Year, End_Year ) • Target Table Tim_Dim ( Date, Day, Month, Year, Quarter ) Stored procedure transformation : A procedure has two input parameters I_Start_Year, I_End_Year and output parameter as O_Date, Day , Month, Year, Quarter. If this session is running, how many rows will be available in the target and why? 39. Two Sources S1, S2 containing measures M1,M2,M3, 4 Dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1, M2,M3 and Dimension Surrogate keys K1,K2,K3,K4 (a) Write a SQL statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of Fact table F1. 40. What is the difference between connected lookup and unconnected lookup?