Friday 26 June 2015

Informatica scenario:How to get top 5 records to target without using rank

Solution:

1.     Drag the source to mapping and connect it to sorter transformation.


2.     Arrange the salary in descending order in sorter as follows and send the record to expression.



3.     Add the next value of sequence generator to expression.(start the value from 1 in sequence generator.


4.     Connect the expression transformation to a filter or router. In the property set the condition as follows-


5.     Finally connect to the target.


No comments:

Post a Comment

subscribe
Subscribe Us
emailSubscribe to our mailing list to get the updates to your email inbox... We can't wait more to have your email in our subscribers email list. Just put your nice email in below box: