select * from(select * from emp order by sal desc) where rownum<=5 MIN

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

Question Posted / bhaskar

Answer Posted / bhaskar

select * from(select * from emp order by sal desc)
where rownum<=5
MINUS
select * from(select * from emp order by sal desc)
where rownum<=4

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain pushdown optimization and types in informatica

1012

Define Pmrep command?

994

Explain informatica architecture - version 8 / 9

1019

How can we create index after completion of load process?

1070

complex mapping ur project u r invlve can u explain and give real time example give me ?

2233

What are the differences between oltp and olap?

919

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1195

How to differentiate between the active and passive transformations?

1068

What is option by which we can run all the sessions in a batch simultaneously?

1077

What is informatica worklet?

983

What is the procedure for creating independent data marts from informatica 7.1?

997

What are the uses of etl tools?

1063

How to elaborate tracing level?

1117

Briefly explain the aggregator transformation?

938

Why do we need informatica?

925