Answer / srikanth

id sal

101 1000

102 1000

103 1000

104 1000


select id, sal from emp where rownum<=3

minus

select id, sal from emp wwhere rownum<=2;

Answer / hardeep

We can use Rank Trx, Select "salary" as Group by port and select "Date" or "Emp_id" as Rank Port and then Filter out records with Rank=3 thru Filter Trx.

Answer / saumyabrata

1>Use a Sequence Generator Transformation,selet Start value
= 1 and Increment By = 1.
2>Use a Filter Transformation,take the ports Person and
Salary from source qualifier and the NEXTVAL port from
Sequence Generator Transformation into it.Set the filter
condition NEXTVAL = 3.

You are done.

Answer / boss

How can you say which is thir record when all the salaries
are same...

Answer / gopi k

rownum is pseudo column, when query extracts rows rownum
will be appended to query. So where rownum = 3 condition is
a wrong one.

Answer / sanju

select * from (select salary.*,rownum r from salary where
sal=(select sal from salary group by sal having count(sal)
=4)) where r=3

Answer / mr.lee

id sal

101 1000

102 1000

103 1000

104 1000

Select Rn, id, Sal, From (
Select Rownum Rn, id ,Sal From Emp)
Where Rn = 3

Answer / vaas

Hi pooja,

would rowid be 3?
can u use having clause in ur query?

pl let me know poojaa

Answer / krishnakanth.ch

It can be retrieved with a simple subquery.

For example, I create a table sal with id,sal

id sal
-------
11 1000
22 1000
33 1000
44 1000

to retrieve the third column with the same salary
use the below query:

select id,sal from (select id,sal,rownum r from sal)
where r=3;

Answer / abhishek

U can achive this by using row_number function in source
qualifer example

select col1,col2,salary,emp_id from (select
col,col2,salary,emp_id , row_number() over (partition by
salary order by emp_id )as rec_seq from table)
Where
rec_seq=3

or by rank t/r in mapping

what is target update override and when we use it?

2 Answers   TCS,

scd methodology?

2 Answers  

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

whatis the default data driven operation in informatica

2 Answers  

When to use normalization transformation other than cobol source?

2 Answers  

why u go for dimensions ?

3 Answers   TCS,

What is junk dimention?

3 Answers   Patni,

can you use flat file for lookup table?why?

2 Answers   HCL,

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers