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

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

Types of error logs in Informatica?

2 Answers  

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

what is inline view?

1 Answers   IBM,

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,