which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?

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


Please Help Members By Posting Answers For Below Questions

What are the types of schemas we have in data warehouse.

751


How to call shell scripts from informatica?

791


What is the cumulative sum and moving sum?

988


What are the uses of etl tools?

892


Different circumstance which drives informatica server to expel records?

763


What is the difference between router and filter?

867


How are indexes created after completing the load process?

1275


what are 3 tech challenges/ common issues you face?

2134


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6044


Define enterprise data warehousing?

893


How to do the error handling of if ur source is flatfiles?

1762


What are junk dimensions?

860


What is Session and Batches?

893


waht type of interface is used for testing the data in informatica

2046


What do mean by local and global repository?

960