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

Why we use partitioning the session in informatica?

2 Answers  

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

What are the join types in joiner transformation?

1 Answers   Informatica,

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  

What is IQD file?

1 Answers  

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

Explain sessions?

0 Answers  

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers