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
What are the types of schemas we have in data warehouse.
How to call shell scripts from informatica?
What is the cumulative sum and moving sum?
What are the uses of etl tools?
Different circumstance which drives informatica server to expel records?
What is the difference between router and filter?
How are indexes created after completing the load process?
what are 3 tech challenges/ common issues you face?
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?
Define enterprise data warehousing?
How to do the error handling of if ur source is flatfiles?
What are junk dimensions?
What is Session and Batches?
waht type of interface is used for testing the data in informatica
What do mean by local and global repository?