Informatica Interview Question and Answers

91. What is difference between ER Modeling and Dimensional Modeling?
 
  • ER Modeling is used for normalizing the OLTP database design.
  • Dimesional modeling is used for de-normalizing the ROLAP / MOLAP design.
 
Your Name Your Email-ID
Your Answer
92. What is the advantage of Lookup persistent cache?
  When Lookup cache is saved in Look up Transformation It is called persistent cache. The first time session runs it is saved on the disk and utilized in subsequent running of the Session. It is used when the look up table is Static i.e. doesn’t change frequently.
 
Your Name Your Email-ID
Your Answer
93. What are all the types of dimensions?
 
  • Informational Dimension
  • Structural Dimension
  • Categorical Dimension
  • Partitioning Dimension
 
Your Name Your Email-ID
Your Answer
94. Which transformation should u need while using the cobol sources as source defintions?
  Normalizer transformaiton which is used to normalize the data.Since cobol sources are oftenly consists of Denormailzed data.
 
Your Name Your Email-ID
Your Answer
95. How many ways you create ports?
 
  • Drag the port from another transforamtion.
  • Click the add buttion on the ports tab.
 
Your Name Your Email-ID
Your Answer
12345678910111213


14151617181920 Page 19 of 20