which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?
- 6 Answers
- 9751 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yaseen
As my knowledge we can write as
select distinctsal from emp A where 5 =
(select count(distinctsal) from emp B where A.sal <= B.sal)
Plz correct me if I am wrong
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
Under which circumstances, informatica server creates reject files?
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 .
What is meant by a domain?
What is complex mapping?
Briefly describe lookup transformation?
How to go to the older version for a mapping?
What is event and what are the tasks related to it?
Write the prerequisite tasks to achieve the session partition?
Tell me about Propagate functions in informatica
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are multi-group transformations?
difference between repository database and repository service?
What are the different clients of powercenter?
Whats the difference between informatica powercenter server, repositoryserver and repository?
