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

What is the need of an ETL tool?

0 Answers   Informatica,

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  

What is Micro Strategy? Why is it used for?

5 Answers   Infosys,

how to get the first row without using rank t/r?

7 Answers   iGate,

what are cost based and rule based approaches and what is the difference?

1 Answers  

Two Default User groups created in the repository are ____ and ______

2 Answers  

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,

In a sequential batch can u run the session if previous session fails?

3 Answers  

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,