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 are Business Components in Informatica?

1 Answers  

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

What are the components of workflow manager?

0 Answers  

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  

How you count the number of records available at your source?

3 Answers   Zensar,

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

What is decode in static cache?

0 Answers  

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

Explain the different dimensions.

0 Answers