Informatica INTERVIEW QUESTION & ANSWERS
|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.|
|52.||What are the types of transformations?|
|53.||What is the difference between active and passive transformations?|
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.
|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.
|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|