Normalizer: The Normalizer transformation is used to generate multiple records from a single record based on columns (transpose the column data into rows)
We can use normalize transformation to process cobol sources instead of source qualifier.
Rank: The Rank transformation allows you to select only the top or bottom rank of data. You can use a Rank transformation to return the largest or smallest numeric value in a port or group.
The Designer automatically creates a RANKINDEX port for each Rank transformation.
Sequence Generator: The Sequence Generator transformation is used to generate numeric key values in sequential order.
Stored Procedure: The Stored Procedure transformation is used to execute externally stored database procedures and functions. It is used to perform the database level operations.
Sorter: The Sorter transformation is used to sort data in ascending or descending order according to a specified sort key. You can also configure the Sorter transformation for case-sensitive sorting, and specify whether the output rows should be distinct. The Sorter transformation is an active transformation. It must be connected to the data flow.
No comments:
Post a Comment