Answer / raka

SQL:
SELECT id, salary from <table name> where rownum <= 10
ORDER BY salary DESC;

Answer / abhilash

do following steps

1.in source qualifier override the query with
"order by salary desc"

2. use seq gen tr on it and give column name as "sid"

3. next use filter tr. in that write condition like "sid<=10"

Answer / amedela chandra sekhar

write sql query in the source qualifier t/r

sql override

select * from(select dense_rank () over (order by sal desc
nulls last)as rnk,emp.* from emp)where rnk<=10;

Answer / krishnakanth

I hope the simpliest way is what Raka #4 suggested
We can override in the SQL override in the source qualifier
transformation.

Answer / murugan

only use the Aggregator function.....

first(sal>=values)

Answer / sarvesh

if it is flat file ur answer is write,if it is relational
souce then go to source qualifier properties there u write
the query like
select distinct a.* from t1 a where 10=(select sal from
t1 b where a.sal>b.sal)
i think it is working

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

7 Answers   iGate,

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  

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

1 Answers  

What is union transformation in informatica?

0 Answers  

Name 4 output files that informatica server creates during session running?

1 Answers  

Why you use repository connectivity?

3 Answers   Yash Technologies,

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

Explain how many types of dimensions are available in informatica?

0 Answers  

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers