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
- 21531 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 is flashback table ? Advance thanks
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is event and what are the tasks related to it?
What is the use of code page?
How many number of sessions can one group in batches?
How to delete duplicate row using informatica?
can u any challenge your project?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
list out all the transformations which use cache?
If informatica has its scheduler why using third party scheduler?
What is the session task and command task?
Quickly characterize reusable change?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the procedure for creating independent data marts from informatica 7.1?
What is parallel processing in informatica?
