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

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

can we use bulk loading when we use look in mapping

1 Answers   TCS,

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

How can you validate all mappings in the repository simultaneously?

0 Answers  

what is the complex transformation you used in informatica

0 Answers   TCS,

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

What is an expression transformation?

0 Answers