Thursday 13 September 2012

Difference between Sorter and Rank transformation in Informatica


Sorter
Rank
Sorter is used to Sort the data either ASC or DSC
Rank is used to arrange data from top or bottom Group by can be done using Rank
Sorter can be used to remove duplicates(Use Distinct ouptut)
Using Rank we cannot remove duplicates
In sorter we cannot assign values to the ports
In rank we can assign variables and write non-aggregate expressions also.
In sorter the Integration Service uses Sorter Cache to perform the sort operation.
In Rank the Integration Service stores group information in an index cache and row data in a data cache.

2 comments:

  1. By giving key colimn as rank and remaining as group by in rank i think we can remove duplicates

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis