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
what is song in infrmatica...?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How many numbers of sessions can one group in batches?
Is it possible to create multiple domains on a single Informatica server?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Tell me about Propagate functions in informatica
What are session parameters ? How do you set them?
What are data-driven sessions?
What are the advantages of using informatica as an etl tool over teradata?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is a difference between complete, stop and abort?
What are mapplets?
Design a mapping to load a target table with the following values from the above source?
Why update strategy and union transformations are active?
What is native users?