FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

Informatica INTERVIEW QUESTION & ANSWERS

Data Warehousing
Follow Us
 
TAGS
51. What is a transformation?
  A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions.
Your Name Your Email-ID
Your Answer
 
52. What are the types of transformations?
 
    There are two types of transformations.
  • Active
  • Passive
Your Name Your Email-ID
Your Answer
 
53. What is the difference between active and passive transformations?
 
    An active transformation can change the number of rows that pass through it, such as a Filter transformation that removes rows that do not meet the configured filter condition.
    A passive transformation does not change the number of rows that pass through it, such as an Expression transformation that performs a calculation on data and passes all rows through the transformation.
Your Name Your Email-ID
Your Answer
 
54. What is the difference between connected and unconnected transformation?
  Connected Transformation : Connected transformation is connected to other transformations or directly to target table in the mapping.
UnConnected Transformation : An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation.
Your Name Your Email-ID
Your Answer
 
55. What parameters can be tweaked to get better performance from a session?
  DTM shared memory, Index cache memory, Data cache memory, by indexing, using persistent cache, increasing commit interval etc
Your Name Your Email-ID
Your Answer