In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / hardeep
We can use Rank Trx, Select "salary" as Group by port and select "Date" or "Emp_id" as Rank Port and then Filter out records with Rank=3 thru Filter Trx.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How do we call shell scripts from informatica?
difference between repository database and repository service?
Differentiate between a repository server and a powerhouse?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Reusable transformation and shortcut differences
What does role playing dimension mean?
How do you promote a non-reusable transformation to reusable transformation?
What are the different clients of powercenter?
What is the difference between a connected look up and unconnected lookup?
How can we improve session performance in aggregator transformation?
What are pre and post-session shell commands?
is it possible to index the data in cache of lkp transformation ?
What is a joiner transformation and why it is an active one?
What is source qualifier transformation in informatica?
What are the types of caches in lookup?