which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?
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
How many ways are there to do 'remove duplicate records in informatica'?
list out all the transformations which use cache?
What are the types of schemas we have in data warehouse.
Explain the pipeline partition with real time example?
what is the Default Source Option For Update Strategy Transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is xml source qualifier transformation in informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to create the source and target database connections in server manager?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the function of aggregator transformation?
What does role playing dimension mean?
What are the different options available for update strategy?
How to do the error handling of if ur source is flatfiles?