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. |
| |
|
| 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. |
| |
|
| 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. |
| |
|
| 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)
|
|
| 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. |
| |
|
Gk Questions with Answers