| Transformation |
Active |
Passive |
Description |
|
SORTER |
 |
__ |
sorting the tables in ascending or descending and aslo to obtain Distinct records. |
|
RANK |
|
__ |
Top or bottom 'N' analysis . |
|
JOINER |
|
__ |
Join two different sources cmng from different and same location . |
|
FILTER |
|
__ |
filters the rows that do not meet the condition. |
|
ROUTER |
|
__ |
It is useful to test multiple conditions . |
|
AGGREGATOR |
|
__ |
To perform group calculation such as count , max , min , sum , avg (mainly to perform calculation or multiple rows or group) |
|
NORMALIZER |
|
__ |
Reads cobol files ( denormalized format).
Split a single row into multiple rows. |
|
SOURCE QUALIFIER |
|
__ |
It performs many tasks such as override default sql query , filtering records , join data from two or more table etc
Represents the flatfile or relational data.
|
|
UNION |
|
__ |
It merges data from multiple sources similar to the UNION ALL SQL statement to combine the results from two or more SQL statements. Similar to the UNION ALL statement, the Union transformation does not remove duplicate rows. |
|
EXPRESSION |
__ |
|
You can use the Expression transformation to calculate values in a single row before you write to the target. |
|
LOOK UP |
__ |
|
Use a Lookup transformation in a mapping to look up data in a flat file or a relational table, view, or synonym. |
|
STORED PROCEDURE |
__ |
|
stored procedures to automate tasks that are too complicated for standard SQL statements.You can call by using Stored Procedure Transformation. |
|
XML SOURCE QUALIFIER |
__ |
|
When you add an XML source definition to a mapping, you need to connect it to an XML Source Qualifier transformation. |
|
UPDATE STRATEGY |
|
__ |
To flag rows for insert, delete, update, or reject.. |
|
|
|
|
|
|
| |
