Interested to Buy Any Domain ? << Click Here >> for more details...
which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?
- 6 Answers
- 10693 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
What is data caches/ index caches?
Explain the code page compatibility?
can u any challenge your project?
How an expression transformation differs from aggregator transformation?
Explain sessions and how many types of sessions are there?
what is size of u r database?
What is a connected transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
COM components can be used in Informatica
Explian the Process of deployment groups in informatica
Describe an informatica powercenter?
Differentiate between joiner and lookup transformation?
Differentiate between Load Manager and DTM?
What is the need of etl tools?
