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
- 10709 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar
Hi Venkatesh,
The above SQL query is not working correctly..
I have one answer for the above problem. The query is, try
it in the SQL override.
select * from emp where sal=(select max(sal) from emp a
where (select count(sal) from emp b where b.sal >=a.sal)=5)
If it wrong means send the correct answers to me
chandranmca2007@gmail.com
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
wf dont have integration severances how you can run?
How do you change a non-reusable transformation to reusable transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is main use of mapplet?
How we can create indexes after completing the loan process?
What is rank transform?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to extract the informatica rejected data?
What is meant by LDAP users?
Which is the t/r that builts only single cache memory?
Which transformation is needed while using the Cobol sources as source definitions?
Different circumstance which drives informatica server to expel records?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Which development components of informatica have the highest usage?
