Informatica Interview Question and Answers

11. What is Operational Data Store?
  A ODS is an operational data store which comes as a second layer in a datawarehouse architecture. It has got the characteristics of both OLTP and DSS systems.
 
Your Name Your Email-ID
Your Answer
12. What is the Difference between OLTP and OLAP?
  OLTP is nothing but OnLine Transaction Processing which contains a normalised tables .
But OLAP(Online Analtical Programming) contains the history of OLTP data which is non-volatile acts as a Decisions Support System.
 
Your Name Your Email-ID
Your Answer
13. How many types of dimensions are available in Informatica?
 
    There are three types of dimensions available are :
  • Junk dimension
  • Degenerative Dimension
  • Conformed Dimension
 
Your Name Your Email-ID
Your Answer
14. What are the designer tools for creating tranformations?
 
  • Mapping designer
  • Transformation developer
  • Mapplet designer
 
Your Name Your Email-ID
Your Answer
15. What is the maplet?
  Maplet is a set of transformations that you build in the maplet designer and you can use in multiple mapings.
 
Your Name Your Email-ID
Your Answer
12345678910111213


14151617181920 Page 3 of 20