Answer / venkateshmalneni

FOR THIS WE HAVE 2 USE TWO T/R ie FIRST WE HAVE 2 USE RANK T/R
AND THEN USE A FILTER T/R IN FILTER GIVE THE CONDITION AS
RANK=5 CONNECT TO TARGET
THE FLOW IS LIKE THIS
SRC --->SQ--->RANK--->FILTER--->TRG

WE CAN ALSO DO THIS IN SQL USE THE FOLLOWING QUERY

SELECT * FROM <TABLE_NAME> WHERE ROWNUM <= 5 MINUS SELECT *
FROM <TABLE_NAME> WHERE ROWNUM <=4;

Answer / 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

Answer / satyanarayana

first one is correct

Answer / 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

Answer / jvdwhinfo

Hi There,

The DFD given in answer is absolutely correct in
informatica.

But coming to sql override stuff i agree with answer 4.
And i want to do little modification keeping performance in
view.
The modified query looks like this.

With salorder
As
(select * from emp)
select * from salorder where rownum <= 5
minus
select * from salorder where rownum <= 4;

Thanks,
James

Answer / 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

Briefly describe lookup transformation?

0 Answers  

What is the need of building a data warehouse?

2 Answers  

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

How do you recover rows from a failed session

1 Answers  

How can we use batches?

0 Answers  

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

whatis the default data driven operation in informatica

2 Answers  

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,