Answer / ramu

Use source Qualifier Transformation,we can edit the default
sql query and write like as
select * from ( select * from emp
order by sal desc)
where rownum <11;

Answer / informatica_learner

use sorter--> expression-->filter
1)sorter descend
2)use sequence generator connected expression to generator
sequence,
3)filter the value sequence number greater than 10

Answer / cool

use sorter transformation with ascending,sequence and filter....

Answer / giri

First use sorter with salary based and sequent generator next filter transformation

Sorter(salary desending order)-----> Sequent genarator

--------->Filter(seq<=10)

Answer / jaipal

it can achieve with inline view query in sqt/r

Answer / infa

If Your Source is Flat file then

1. Sort the sal column in Desc order

2. generate the sequence rownumber either by using a sq
genrator or Exp Transformation say v_count+1

3. use a filter condition and give the filter value as
v_count <= 10

4.Load into the target.

If your source is DB
then use below query

SELECT *FROM
(
SELECT *FROM emp
ORDER BY Sal desc
)
WHERE rownum <= 10
ORDER BY Sal;

Thanks

cheers

Answer / chinthi

SELECT t.sal from ( SELECT sal, Row_Number() OVER (ORDER
BY sal desc) AS rownum FROM table ) t WHERE t.rownum <=
10

Answer / rakhee

No need to use any transformation.
Double click on SQ emp
go to property
click on SQL query
browse it

write query
SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO
FROM
EMP
WHERE
ROWNUM<=10
ORDER BY SAL DESC

validate it
OK

Answer / chandu

select distinct a.sal from emp a where 10>=(select
count(distinct b.sal from emp b where a.sal<=b.sal)order by
a.sal desc

Answer / jvdwhinfo

Write sql override in the source qualifier t/r.
select columns from
( select columns,rank() over(order by sal desc ) as
rank from emp)
where rank <=10;
let me know if any corrections.

Thanks.
James

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

What is workflow? What are the components of workflow manager?

0 Answers  

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

What is workflow monitor?

0 Answers  

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

How do you recover rows from a failed session

1 Answers  

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

What do you mean incremental aggregation?

0 Answers