In a table, 4 person having same salary. How to get Third
person record only?
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 update strategy mean, and what are the different option of it?
What is informatica etl tool?
Explain the shared cache and re-cache?
update strategy transformation in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What all join we can perform in LOOKUP transformation?
What are the different lookup cache(s)?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the modules in Power Center
What are mapplets?
Explain joiner transformation in informatica
What is joiner transformation?
What are the different options available for update strategy?
How can you validate all mappings in the repository simultaneously?
What are the features of complex mapping?