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

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

what is session parameters?

1 Answers   Cap Gemini,

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

How does a rank transform differ from aggregator transform functions max and min?

0 Answers  

why we use materialized view over view?

1 Answers   Zensar,

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

What is mapplet and a reusable transformation?

2 Answers  

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,