Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21687 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhishek
U can achive this by using row_number function in source
qualifer example
select col1,col2,salary,emp_id from (select
col,col2,salary,emp_id , row_number() over (partition by
salary order by emp_id )as rec_seq from table)
Where
rec_seq=3
or by rank t/r in mapping
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does cheating measurement mean?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is option by which we can run all the sessions in a batch simultaneously?
What is the session task and command task?
How can one identify whether mapping is correct or not without connecting session?
Explain the scenario which compels informatica server to reject files?
Performance tuning in UNIX for informatica mappings?
What is the difference between informatics 7x and 8x and what is latest version?
What are data-driven sessions?
What is persistent lookup cache?
what is song in infrmatica...?
What are the types of lookup transformation?
How can we store previous session logs?
difference between repository database and repository service?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
