Informatica INTERVIEW QUESTION & ANSWERS
| 66. |
What is Aggregator Transformation? |
| |
- Aggregator transformation is an Active and Connected transformation.
- The Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.
- The Aggregator transformation is unlike the Expression transformation, in that you can use the Aggregator transformation to perform calculations on groups.
- The Expression transformation permits you to perform calculations on a row-by-row basis only.
|
| 67. |
What is filter transformation? |
| |
- Filter transformation is an Active and Connected transformation.
- The Filter transformation provides the means for filtering rows in a mapping. You pass all the rows from a source transformation through the Filter transformation, and then enter a filter condition for the transformation.
|
| 68. |
What is Joiner transformation? |
| |
Joiner Transformation is an Active and Connected transformation. This can be used to join two sources coming from two different locations or from same location. The Joiner transformation to join two sources with at least one matching port. The Joiner transformation uses a condition that matches one or more pairs of ports between the two sources. |
| 69. |
What is clustering? |
| |
Clustering is the process of grouping the data into classes or clusters so that objects with in a cluster have high similarity in comparison to one another, but are very dissimilar to objects in other clusters. |
| 70. |
What is difference between aggregator and expression? |
| |
Aggregator is active transformation and Expressionis passive transformation. Aggregator transformation used to perform aggregate calculation on group of records
Where as expression used perform calculation with single record. |
