How to list Top 10 salary, without using Rank Transmission?

Answers were Sorted based on User's Feedback



How to list Top 10 salary, without using Rank Transmission?..

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;

Is This Answer Correct ?    29 Yes 2 No

How to list Top 10 salary, without using Rank Transmission?..

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

Is This Answer Correct ?    27 Yes 3 No

How to list Top 10 salary, without using Rank Transmission?..

Answer / cool

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

Is This Answer Correct ?    18 Yes 2 No

How to list Top 10 salary, without using Rank Transmission?..

Answer / giri

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

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

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

Is This Answer Correct ?    13 Yes 1 No

How to list Top 10 salary, without using Rank Transmission?..

Answer / jaipal

it can achieve with inline view query in sqt/r

Is This Answer Correct ?    7 Yes 2 No

How to list Top 10 salary, without using Rank Transmission?..

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

Is This Answer Correct ?    2 Yes 0 No

How to list Top 10 salary, without using Rank Transmission?..

Answer / chinthi

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

Is This Answer Correct ?    0 Yes 0 No

How to list Top 10 salary, without using Rank Transmission?..

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

Is This Answer Correct ?    2 Yes 2 No

How to list Top 10 salary, without using Rank Transmission?..

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

Is This Answer Correct ?    0 Yes 1 No

How to list Top 10 salary, without using Rank Transmission?..

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

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,


Differences between connected and unconnected lookup?

0 Answers  


If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers   Hexaware,


Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,


What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,






SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,


Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,


tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,


What is sq transformation?

0 Answers  


in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,


What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  


How to load a relational source into file taget?

2 Answers  


Categories