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)
|
We can remove duplicates using Rank
|
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.
|
Wednesday, January 30, 2013
Difference between Sorter and Rank transformation in Informatica?
Subscribe to:
Post Comments (Atom)
Tags
Architecture of UNIX
(1)
Basic Unix Commands
(1)
Data warehousing Quiestions1
(1)
Debugger
(1)
Downloads
(1)
ETL Process
(1)
Fundamentals of UNIX
(1)
Get top 5 records to target without using rank
(1)
Home
(1)
How do you perform incremental logic or Delta or CDC
(1)
Incremental Loading for Dimension Table
(1)
Informatica Complete Reference
(1)
Informatica Functions
(1)
Informatica Powercenter Architecture
(1)
informatica project
(1)
Informatica Quiestions
(1)
Informatica Quiestions3
(1)
Informatica Real time Scenarios
(2)
Informatica scenarios
(3)
Integration Testing
(1)
Introduction of Unix
(1)
Oracle Queries
(1)
Power center Client
(1)
Separate rows on group basis
(1)
TESTING-User Acceptance Test
(1)
Unit Testing
(1)
Unix
(2)
What is informatica
(1)
No comments:
Post a Comment
Thank you :
- kareem