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

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

How many ways are there to create ports?

1 Answers   Informatica,

What is data merging, data cleansing and sampling?

6 Answers   Satyam,

Can you copy the session to a different folder or repository?

2 Answers  

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

What is polling?

1 Answers  

What is difference between maplet and reusable transformation?

2 Answers  

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1 Answers  

What are the reusable transforamtions?

1 Answers