Informatica Interview Question and Answers

86. What are the types of designer tools?
 
    The Designer provides the following tools are :
  • Source Analyzer
  • Warehouse Designer
  • Transformation Developer
  • Mapplet Designer
  • Mapping Designer
 
Your Name Your Email-ID
Your Answer
87. What is the subquery?
  Subquery is a query whose return values are used in filtering conditions of the main query.
 
Your Name Your Email-ID
Your Answer
88. What is tracing level?
  Tracing level represents the amount of information that informatcia server writes in a log file.
 
Your Name Your Email-ID
Your Answer
89. Why you use repository connectivity?
  When you edit,schedule the sesion each time,informatica server directly communicates the repository to check whether or not the session and users are valid.All the metadata of sessions and mappings will be stored in repository.
 
Your Name Your Email-ID
Your Answer
90. What are the options in the target session of update strategy transformation?
 
  • Insert
  • Delete
  • Update
  • Update as update
  • Update as insert
  • Update else insert
  • Truncate table
 
Your Name Your Email-ID
Your Answer