Informatica Interview Questions & Answers(Informatica)

<<Prev: Informatica Interview Questions & Answers(General)

• 1. How do you 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).

1. where is the reject loader .

   1. How do you use reject loader.

   2. Do u have to change the reject file b4 using reject loader utility.

   3. Differences between version 7.x and 8.x.

   4. 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.

   5. Mapplets – can you use an active transformation in a mapplet,

   6. What are active transformations? Name them.

   7. Can u use flat files in Mapplets.

   8. How many transformations can be used in mapplets.

   9. Can a joiner be used in a mapplet.

   10. What are active transformations.

   11. How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

   12. Global and Local shortcuts. Advantages.

   13. Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can u use them in the mapping?

   14. Have you worked with/created Parameter file

   15. What’s the layout of parameter file (what does a parameter file contain?)?

   16. Why do u use Mapping Parameter and mapping variable?

   17. Where do u create/define mapping parameter and mapping variable?

   18. 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

   19. Slowly changing dimensions, types and where will you use them

   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. Parameter&variable differences

   23. Reusable transformation & shortcut differences

   24. Mapplets ( can u use source qyalifier, can u use sequence generator, can u use target)

   25. Implementation methodology

   26. Do u have knowledge in ralph kimball methodology

   27. According to his methodology what all u need before u build a datawarehouse

   28. How do u recover rows from a failed session

   29. Sequence generator, when u move from develoment to production how will u reset

   30. Whats there in global repository

   31. Repository user profiles

   32. How do u set a varible in incremental aggregation

   33. Can u create a flatfile target

   34. What did u do in source pre load stored procedure

   35. Scheduling properties,whats the default (sequential)

   36. In a concurrent batch if a session fails, can u start again from that session

   37. When u move from devel to prod how will u retain a variable

   38. Partition, what happens if the specified key range is shorter n longer

   39. Performance tuning( what u did in performance tuning)

   40. What are conformed dimensions?

   41. what are factless facts? And in which scenario will you use such kinds of fact tables.

   42. can you avoid static cache in the lookup transformation? I mean can you

   43. disable caching in a lookup transformation?

   44. what is the meaning of complex transformation?

   45. in any project how many mappings they will use(minimum)?

   46. How do u implement unconn. Stored proc. In a mapping?

   47. Can u access a repository created in previous version of Informatica?

   48. What happens if the info. Server doesn’t find the session parameter in the parameter file?

   49. How big was your fact table

   50. 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

   51. How will u convert rows into columns or columns into rows

   52. What are the steps involved in the migration from older version to newer version of Informatica Server?

   53. What are the main features of Oracle 8i with context to datawarehouse?

   54. What are the new features of Power Center 5.0?

   55. How to run a session, which contains mapplet?

   56. Differentiate between Load Manager and DTM?

   57. What are session parameters ? How do u set them?

   58. When do u use mapping parameters? (In which transformations)

   59. What is a parameter When and where do u them when does the value will be created

   60. Desing time, run time. If u don’t create parameter what will happen

   61. What are variable ports and list two situations when they can be used?

   62. What are the parts of Informatica Server?

   63. How does the server recognize the source and target databases. Elaborate on this.

   64. List the transformation used for the following:

       1. Heterogeneous Sources

       2. Homogeneous Sources

       3. Find the 5 highest paid employees within a dept.

       4. Create a Summary table

       5. Generate surrogate keys

   65. What is the difference between sequential batch and concurrent batch and which is recommended and why?

   66. A session S_MAP1 is in Repository A. While running the session error message has displayed

   67. ‘server hot-ws270 is connect to Repository B ‘. What does it mean?

   68. How do you do error handling in Informatica?

   69. How do you implement scheduling in Informatica?

   70. What is the meaning of up gradation of repository?

   71. How can you run a session without using server manager?

   72. Consider two cases:

   73. 1. Power Center Server and Client on the same machine

   74. 2. Power Center Sever and Client on the different machines

   75. what is the basic difference in these two setups and which is recommended?

   76. 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?

   77. When you connect to repository for the first time it asks you for user name & password of repository and database both.

   78. But subsequent times it asks only repository password. Why?

   79. What is the difference between normal and bulk loading?

   80. Which one is recommended?

   81. What is a test load?

   82. How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

   83. What is the difference between a shortcut of an object and copy of an object?

   84. Compare them.

   85. What is mapplet and a reusable transformation?

   86. How do you implement configuration management in Informatica?

   87. What are Business Components in Informatica?

   88. Dimension Object created in Oracle can be imported in Designer

   89. Cubes contain measures

   90. COM components can be used in Informatica

   91. What is the advantage of persistent cache? When it should be used.

   92. When will you use SQL override in a lookup transformation?

   93. Two different admin users created for repository are ______ and_______

   94. Two Default User groups created in the repository are ____ and ______

   95. A mapping contains

• • 1. Source Table S_Time ( Start_Year, End_Year )

    2. Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1. 96. 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?

   97. Two Sources S1, S2 containing measures M1,M2,M3, 4 Dimensions D1,D2,D3,D4,

   98. 1 Fact F1 containing measures M1, M2,M3 and Dimension Surrogate keys K1,K2,K3,K4

• • 1. Write a SQL statement to populate Fact table F1

    2. Design a mapping in Informatica for loading of Fact table F1.

1. 99. What is the difference between connected lookup and unconnected lookup?

   100. How can you import a flat file or relational sources to your work area?

   101. What is active and passive transformation and how many active and passive transformations are there?

   102. What is meant of performance tuning and what are the parameters for increasing performance.

   103. Why is meant by direct and indirect loading options in sessions?

   104. What is scheduling and how many types of scheduling options are there?

   105. What are batches and what are the types of batches?

   106. What is difference between stored procedure transformation and lookup transformation and where to use which one?

   107. What is difference between SQL override and lookup override?

   108. What is staging area in informatica and where it exist and do we need it and how much of data can it store?

   109. What is ODS and how much of information can it store in it and what are data marts?

   110. Interviewer may ask draw your architecture of your project and informatica architecture?

   111. How can you handle errors in informatica and how can you identify them?

   112. What is auxiliary mapping and where in appears?

   113. What is difference between Mapplets and reusable transformations?

   114. In which scenario we can use unconnected and connected lookup transformation and stored procedure?

   115. In which scenario we can use update strategy transformation and how many ways that we can use update strategy transformation.

   116. What is difference between filter transformation and router transformation?

   117. What is difference between source qualifier transformation and joiner transformation?

   118. In a scenario I want to change the dimensions of a table and normalize the denoralized table which transformation can I use?

   119. Why we use lookup condition in lookup transformation?

   120. How can you delete duplicate records from a flat file and also from a relational file?

   121. What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

   122. If am having n rows in my source and I want n+ 1 row in my target what is the logic that I can go for.

   123. How many types of caches are there in informatica? And what is difference between static and dynamic cache?

   124. Which caches are used when you use aggregator, filter, rank, join, sequence generator transformation?

   125. How can u increase the cache size and what is the maximum size?

   126. In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

   127. What is informatica server background?

   128. What is pmcmd? Where is works?

   129. What are worklets?

   130. When u use an update strategy transformation what are the parameters you had to go for? And what is forward reject rows and what happens if we not enable this option and what happens if we place a target next to the update transformation will they appear?

   131. What is materialized view and in which scenario it works and have u implemented any MV?

   132. If am having n tables how many joiner transformations I require to join them and what is the condition that I need to join any two tables?

   133. How can we call an unconnected lookup and stored procedure in a mapping and from which transformation we can call them?

   134. What is CDC and in which scenario in works?

   135. How can u import a file which is having a header and footer into source analyzer?

   136. What is fact constellation and how many facts and dimensions are there in your project and how many mappings you have done in your project, can u name them?

   137. What is a complex mapping had u done any complex mapping in your project?

   138. Explain what is SCD and types of scd’s and which one works in which scenario?

   139. What is mapping parameters and mapping variables and where can we use them and can we use them in another mapping also?

   140. Why we use stored procedures?

   141. Can we create an n number of tasks from a single mapping?

   142. What is event raise and event wait?

   143. What are partitions in informatica and how many types of partitions are there and can u make partitions on a flat file?

   144. Explain about cubes and dimensions?

   145. What are the components of informatica?

   146. What is debugger and what is the advantage of going for that?

   147. If u have no accessible to debugger and run workflow monitor how can u know that your mapping is successful?

   148. What is target load order and what is target load plan?

   149. Think that your source is COBOL file and which transformation will u use to import?

   150. What is the size of ur project and size of the data that u use in mappings, and size of the staging area?

   151. How can u join a flat and relational without having any matching keys?

   152. What is MOLAP, DOLAP?

   153. What is slice and dicing?

   154. What is table mutating?

   155. What is xx_sh_alloc, where does this appear?

   156. How can u identify that a table is partitioned or not?

   157. What is purpose of “dd” in update strategy transformation?

   158. What are DTM and LM?

   159. How can u recover a session if it fails in between?

   160. How many types are there to create a reusable transformation?

   161. A table having 100 records in it and how can you copy these records to another table in oracle?

   162. What are the output files that informatica server creates when session runs?