How to list Top 10 salary, without using Rank Transmission?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / cool
use sorter transformation with ascending,sequence and filter....
Is This Answer Correct ? | 18 Yes | 2 No |
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 |
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 |
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 |
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 |
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
Differences between connected and unconnected lookup?
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?
Limitation of REPLACESTR. Is there any character limitation to it.
What is the commit type if you have a transaction control transformation in the mapping?
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
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
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)?
What is sq transformation?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
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
How to load a relational source into file taget?