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.
|
A blog where you can explore everything about Datawarehouse, OBIEE, Informatica, Power BI, QlikView, Hadoop, Oracle SQL-PLSQL, Cognos and much more....
Thursday 13 September 2012
Difference between Sorter and Rank transformation in Informatica
Subscribe to:
Post Comments (Atom)
By giving key colimn as rank and remaining as group by in rank i think we can remove duplicates
ReplyDeletethank u
ReplyDeletewhat is rank cache