Informatica Interview Question and Answers

26. Why we use lookup transformations?
  Lookup Transformations can access data from relational tables that are not sources in mapping.
 
Your Name Your Email-ID
Your Answer
27. What are Normalizer transformation?
  Normalizer Transformation is an Active and Connected transformation. It is used mainly with COBOL sources where most of the time data is stored in denormalized format. Also, Normalizer transformation can be used to create multiple rows from a single row of data.
 
Your Name Your Email-ID
Your Answer
28. What are Rank transformation?
  Rank transformation is an Active and Connected transformation. It is used to select the top or bottom rank of data.
 
Your Name Your Email-ID
Your Answer
29. What are Router transformation?
  Router transformationis an Active and Connected transformation. It is similar to filter transformation. The only difference is, filter transformation drops the data that do not meet the condition whereas router has an option to capture the data that do not meet the condition. It is useful to test multiple conditions.
 
Suresh,says Apr 23, 2014
Router is Active & connected T/R. It is Similar to filter T/R). Router T/R having 2 groups. 1. User defined Group( Meet the condition) 2 . Default group ( Do not meet the condition)
Your Name Your Email-ID
Your Answer
30. What are Sorter transformation?
  Sorter transformation is a Connected and an Active transformation. It allows to sort data either in ascending or descending order according to a specified field.
 
Your Name Your Email-ID
Your Answer
12345678910111213


14151617181920 Page 6 of 20